REPOST: Re: Dealing with case sensitivity

Your best bet is to create a function based index eg create index my_idx on myTable(upper(theColumn)...
then you can search like
select .. from myTable where upper(theColumn) like 'HA%';

you need to set query_rewrite=trusted and analyze the table. Jim
"John Harris" <harris.john.a_at_worldnet.att.net> wrote in message news:iGJ48.4247$Ab1.269199_at_bgtnsc04-news.ops.worldnet.att.net...
> 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: "Jim Kennedy" <kennedy-family_at_attbi.com> Control: cancel <emK48.3997$Ox4.17544_at_rwcrnsc51.ops.asp.att.net> Subject: cmsg cancel <emK48.3997$Ox4.17544_at_rwcrnsc51.ops.asp.att.net> Date: Mon, 28 Jan 2002 02:37:35 GMT Message-ID: <cancel.emK48.3997$Ox4.17544_at_rwcrnsc51.ops.asp.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!netnews.web.de!blackbush.xlink.net!blackbush.de.kpnqwest.net!newsfeed.freenet.de!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp03!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40715961

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 - 21:20:42 CST