Xref: alice comp.databases.oracle.server:48254
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!news-xfer.mccc.edu!usenet.co.uk!newspeer.usenet.co.uk!post.usenet.co.uk!not-for-mail
From: "Super Kev" <steve.bright@capgemini.co.uk>
Newsgroups: comp.databases.oracle.server
Subject: Case insensitive selects
Date: Wed, 5 May 1999 11:16:54 +0100
Organization: USENET UK
Lines: 23
Message-ID: <7gp5qp$d3d$1@hagen.cloud9.co.uk>
X-Trace: hagen.cloud9.co.uk 925899417 13421 194.42.240.2 (5 May 1999 10:16:57 GMT)
X-Complaints-To: abuse@usenet.co.uk
NNTP-Posting-Date: 5 May 1999 10:16:57 GMT
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

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