Re: Making a search case insensitive
From: Lee Miller <lpm_at_newsguy.com>
Date: Wed, 7 Feb 2001 15:44:22 -0500
Message-ID: <95sc390114l_at_enews1.newsguy.com>
Date: Wed, 7 Feb 2001 15:44:22 -0500
Message-ID: <95sc390114l_at_enews1.newsguy.com>
[Quoted] 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 - 21:44:22 CET