Re: SQL Command

Tanel Poder wrote:
>
> > 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.

How much of any index would it use with a LIKE where the comparison string begins with a wild card?
But I know what you mean about 'this kind' of query. Received on Tue Mar 25 2003 - 02:16:35 CST