Re: Making a search case insensitive
From: Matt B. <mcb_at_ds.znet.com>
Date: Wed, 7 Feb 2001 21:22:22 -0800
Message-ID: <t84b2k1nu53315_at_corp.supernews.com>
Date: Wed, 7 Feb 2001 21:22:22 -0800
Message-ID: <t84b2k1nu53315_at_corp.supernews.com>
"Jeff Boyer" <jdboyer_at_(remove)icomproductions.ca> wrote in message
news: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
Put either an UPPER or a LOWER function around each column name and value you are searching for.
Ex:
...
WHERE upper(my_column) like upper('mystring%')
...
-Matt Received on Thu Feb 08 2001 - 06:22:22 CET