Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: query
select * from TABLE where COLUMN like '%column%';
To remove case sensitivity:
select * from TABLE where lower(COLUMN) like '%column%';
>
Received on Thu Jan 24 2002 - 10:08:31 CST