Re: REPOST: Dealing with case sensitivity

Yea...that is what I meant.
I noticed that right after I uploaded it.

:)

Mike Casey

"Daniel A. Morgan" <damorgan_at_exesolutions.com> wrote in message news:3C5AC6DE.F49CA6E7_at_exesolutions.com...
> Unlikely.
>
> UPPER('ha%')
>
> is the same as
>
> ('HA%')
>
> I think your upper is on the wrong side of the equals sign.
>
> Daniel Morgan
>
>
>
>
>
> Mike Casey wrote:
>
> > 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 Mon Feb 04 2002 - 17:11:39 CST