REPOST: Re: Dealing with case sensitivity

Or

SELECT *
FROM employee
WHERE UPPER(lastname) LIKE UPPER('ha%');

But I definitely like the use of function based indexes where appropriate.

Daniel Morgan

Bricklen Anderson wrote:

> try: select * from employee where lastname like UPPER('HA%');
>
> John Harris wrote:
> >
> > 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: "Daniel A. Morgan" <damorgan_at_exesolutions.com> Control: cancel <3C53E19F.E485818A_at_exesolutions.com> Subject: cmsg cancel <3C53E19F.E485818A_at_exesolutions.com> Date: Mon, 28 Jan 2002 00:00:25 GMT Message-ID: <cancel.3C53E19F.E485818A_at_exesolutions.com> 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!newsfeed00.sul.t-online.de!t-online.de!newsfeed.freenet.de!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp03!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40715898

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Sun Jan 27 2002 - 05:16:47 CST