Re: Making a search case insensitive

Just remember that adding the fuction will invalidate the use of an index for your search. If you are running 8.1.x you can build a fuction based index so the search will perform better.

E

Jeff Boyer wrote:
>
>
> Great, that worked..........
>
> Thanks for your time,
> Jeff
> "Lee Miller" <lpm_at_newsguy.com> wrote in message
> news:95sc390114l_at_enews1.newsguy.com...
> > Upper() or Lower() the column and value to compare it to
> >
> > Jeff Boyer wrote in message <95sdek$qmu$1_at_news3.cadvision.com>...
> > >I am using the SQL statement:
> > >
> > >SELECT COMPANY_ID, COMP_NAME, COMP_ADDY, COMP_CITY, COMP_PROV,
 COMP_CNT,
> > >CON_PHONE
> > >FROM RAT.COMPANY_REG
> > >WHERE COMP_NAME LIKE 'MMColParam%' or CON_PHONE LIKE 'varPhone%'
> > >
> > >As the statement stands right now, it IS case sensitive, how do I make
 it
 so
> > >it is NOT case sensitive?
> > >
> > >Thanks,
> > >Jeff
> > >
> > >
> > >
> > >
> >
> >
>
>

--
Posted via CNET Help.com
http://www.help.com/