How does one handle case sensitivity with string searches using the LIKE
operator?
If I have something like: select * from employee where lastname LIKE "ha%"
But I want to get all possibilities regardless of case sensitivity - harris,
Harris HArris HARRIS haRRis...
Is this possible with straight SQL against an Oracle database?
John Harris
- WAS CANCELLED BY =======:
From: "John Harris" <harris.john.a_at_worldnet.att.net>
Control: cancel <iGJ48.4247$Ab1.269199_at_bgtnsc04-news.ops.worldnet.att.net>
Subject: cmsg cancel <iGJ48.4247$Ab1.269199_at_bgtnsc04-news.ops.worldnet.att.net>
Date: Mon, 28 Jan 2002 00:29:27 GMT
Message-ID: <cancel.iGJ48.4247$Ab1.269199_at_bgtnsc04-news.ops.worldnet.att.net>
X-No-Archive: yes
Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.misc
NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88
Lines: 1
Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!t-online.de!fr.clara.net!heighliner.fr.clara.net!news-x2.support.nl!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp03!u&n&a&c&anceller
Xref: news.uni-stuttgart.de control:40715939
This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers.
Received on Sat Jan 26 2002 - 20:33:50 CST