Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: REPOST: Dealing with case sensitivity

Re: REPOST: Dealing with case sensitivity

From: Mike Casey <mcasey_at_rcrh.org>
Date: Fri, 1 Feb 2002 16:20:26 -0700
Message-ID: <8SF68.784$PC4.76633@news.uswest.net>


I think this will work:
select * from employee where lastname LIKE Upper('ha%')

"John Harris" <harris.john.a_at_worldnet.att.net> wrote in message news:8$--$%%%_$_%%$%_%$@news.noc.cabal.int...
> 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 Fri Feb 01 2002 - 17:20:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US