Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Command
> SELECT description
> FROM stock
> WHERE UPPER(description) LIKE '%APPLES%'; or
>
> SELECT description
> FROM stock
> WHERE LOWER(description) LIKE '%apples%';
Note that this kind of query isn't able to use any normal indexes on column description if you don't create function based indexes on UPPER or LOWER function.
Tanel. Received on Mon Mar 24 2003 - 15:01:19 CST