Received: from funredes.org (funredes.org [205.160.164.9]) by hub.org (8.9.3/8.9.3) with SMTP id KAA22391 for ; Thu, 12 Aug 1999 10:54:25 -0400 (EDT) (envelope-from mike@fieldco.com) Received: from mike (net0port190.tricom.net) by funredes.org (5.x/SMI-SVR4) id AA10209; Thu, 12 Aug 1999 10:56:59 -0400 Message-Id: <003401bee4d3$42774e20$0200a8c0@mike> From: "Mike Field" To: Subject: Searching Text Fields - Case Sensitive? Date: Thu, 12 Aug 1999 10:59:20 -0400 Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0031_01BEE4B1.BB65AE20" X-Priority: 3 X-Msmail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3155.0 X-Mimeole: Produced By Microsoft MimeOLE V4.72.3155.0 This is a multi-part message in MIME format. ------=_NextPart_000_0031_01BEE4B1.BB65AE20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi- If I want to search a text field for a certain word, say 'foobar', = using: SELECT * FROM mydb WHERE description LIKE "%foobar%"; it seems to be case sensitive. Is there a way to do it so it is NOT = case-sensitive? Please let me know. Thanks, Mike mike@fieldco.com ------=_NextPart_000_0031_01BEE4B1.BB65AE20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi-
 
If I want to search a text field for a certain word, = say=20 'foobar', using:
 
SELECT * FROM mydb WHERE description LIKE=20 "%foobar%";
 
it seems to be case sensitive.  Is there a way = to do it=20 so it is NOT case-sensitive?
 
Please let me know.
Thanks,
Mike
 
mike@fieldco.com
 
------=_NextPart_000_0031_01BEE4B1.BB65AE20--