REPOST: Re: Dealing with case sensitivity

From: Fernão Magalhaes <barameda_at_h.o.t.m.a.i.l.com>
Date: Sun, 27 Jan 2002 13:30:53 -0800
Message-ID: <3$--$%%%_$_$__$-$$@news.noc.cabal.int>

Do you mean:

SELECT * FROM employee WHERE UPPER(lastname) like 'HA%';

--Fernão
DBA wannabe

"Bricklen Anderson" <bricklen_at_shaw.ca> wrote in message news:3C539E8F.A15893B8_at_shaw.ca...
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: "Fernão Magalhaes" <barameda_at_h.o.t.m.a.i.l.com> Control: cancel <eHgNHs4pBHA.584_at_cpimsnntpa03> Subject: cmsg cancel <eHgNHs4pBHA.584_at_cpimsnntpa03> Date: Mon, 28 Jan 2002 02:07:02 GMT Message-ID: <cancel.eHgNHs4pBHA.584_at_cpimsnntpa03> 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!news.fh-hannover.de!fu-berlin.de!newspeer.monmouth.com!news.maxwell.syr.edu!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp03!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40715896

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 - 15:30:53 CST