Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!uflorida!haven!grebyn!jan
From: jan@grebyn.COM (Jan Baron)
Newsgroups: comp.databases
Subject: Re: Using Indexes in Oracle
Message-ID: <11813@grebyn.COM>
Date: 14 Feb 89 21:55:10 GMT
References: <6555@bunny.UUCP>
Reply-To: jan@grebyn (Jan Baron)
Distribution: na
Organization: Grebyn Corp. & Timesharing Customers; Vienna, VA
Lines: 15

An easy way to get around this is as follows:

select * from tablename where upper(columnname) = upper(comparestring);

If you upper (or lower) both sides of the comparison, then you don't
have to worry about case.  This only affects the comparison itself.
It doesn't change the database values.

I hope this is of some help.

-- 
***********************************************************************
* ...another day, another quarter...  * Jan A. Baron (jan@grebyn.com) *
*      (inflation, y'know)            * ...!{uunet,hadron}!grebyn!jan *
***********************************************************************