Re: case insensitive query?
From: Parry <PARRY_CHU_at_HOTMAIL.COM>
Date: Fri, 27 Apr 2001 14:19:34 +0800
Message-ID: <9cb312$c24$1_at_news.hk.linkage.net>
Date: Fri, 27 Apr 2001 14:19:34 +0800
Message-ID: <9cb312$c24$1_at_news.hk.linkage.net>
I guess...
SELECT NAME
FROM ADDRES
WHERE UPPER(NAME) LIKE '%BART%'
-- ALL NAME CONTAIN 'BART'
SELECT NAME
FROM ADDRES
WHERE NAME LIKE '%Bart%' OR NAME LIKE '%bart%'
-- ALL NAME CONTAIN ONLY 'Bart' Or 'bart'
Received on Fri Apr 27 2001 - 08:19:34 CEST