Xref: alice comp.databases.oracle.server:48392
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.cwix.com!24.93.67.47!cyclone.southeast.rr.com!newse1.tampabay.rr.com!newse3.tampabay.rr.com.POSTED!not-for-mail
Message-ID: <3730FD72.E6559B3C@pobox.com>
From: John Seitz <seitz@pobox.com>
Reply-To: seitz@pobox.com
X-Mailer: Mozilla 4.51 [en] (Win98; I)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: Case insensitive selects
References: <7gp5qp$d3d$1@hagen.cloud9.co.uk>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 28
Date: Thu, 06 May 1999 02:23:44 GMT
X-Complaints-To: newsabuse@tampabay.rr.com
X-Trace: newse3.tampabay.rr.com 925957424 24.92.215.28 (Wed, 05 May 1999 22:23:44 EDT)
NNTP-Posting-Date: Wed, 05 May 1999 22:23:44 EDT
Organization: RoadRunner - TampaBay

I don't believe that Oracle has that type of switch/parameter.  I think Sybase
does, but that is a complete other newsgroup.

John


Super Kev wrote:

> I think this has been on the NG recently, and I think I know the answer BUT
> ......
>
> can somebody confirm that there is no instance parameter that can make a
> select statement case insensitive..
>
> e.g   select username from employees where username like 'smi%';
>
>   to return SMITH, Smithers, sMithereens etc , etc.....
>
> I know I can use upper() and lower() functions ...
>
> Using Oracle8.0.5 on NT
>
> Cheers
>
> Steve Bright
>
> steve.bright@capgemini.co.uk