REPOST: Re: Dealing with case sensitivity

From: Bricklen Anderson <bricklen_at_shaw.ca>
Date: Sun, 27 Jan 2002 06:32:39 GMT
Message-ID: <0$--$%%%%--__%$$%$@news.noc.cabal.int>

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: Bricklen Anderson <bricklen_at_shaw.ca> Control: cancel <3C539E8F.A15893B8_at_shaw.ca> Subject: cmsg cancel <3C539E8F.A15893B8_at_shaw.ca> Date: Mon, 28 Jan 2002 01:17:20 GMT Message-ID: <cancel.3C539E8F.A15893B8_at_shaw.ca> 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!news.csl-gmbh.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:40715945

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 - 00:32:39 CST