"Tanel Poder" <tanel@@peldik.com> wrote in message
news:3e7f715e$1_2_at_news.estpak.ee...
> > 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.
True, but if the pattern starts with %, an index won't help anyway.
Stephan
Received on Tue Mar 25 2003 - 02:27:03 CST
