Re: Making a search case insensitive

[Quoted] 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
> >
> >
> >
> >
>
>
Received on Wed Feb 07 2001 - 22:38:12 CET