Making a search case insensitive
From: Jeff Boyer <"Jeff>
Date: Wed, 7 Feb 2001 13:01:39 -0700
Message-ID: <95sdek$qmu$1_at_news3.cadvision.com>
Date: Wed, 7 Feb 2001 13:01:39 -0700
Message-ID: <95sdek$qmu$1_at_news3.cadvision.com>
I am using the SQL statement:
[Quoted] SELECT COMPANY_ID, COMP_NAME, COMP_ADDY, COMP_CITY, COMP_PROV, COMP_CNT,
CON_PHONE
FROM RAT.COMPANY_REG
[Quoted] [Quoted] 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 [Quoted] it is NOT case sensitive?
Thanks,
Jeff
Received on Wed Feb 07 2001 - 21:01:39 CET