Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!tut.cis.ohio-state.edu!bloom-beacon!husc6!bunny!pm04
From: pm04@bunny.UUCP (Preeti Mehta)
Newsgroups: comp.databases
Subject: Using Indexes in Oracle
Message-ID: <6555@bunny.UUCP>
Date: 13 Feb 89 23:59:13 GMT
Reply-To: pm04@bunny.UUCP (Preeti Mehta)
Distribution: na
Organization: GTE Laboratories, Waltham, MA
Lines: 13


Does anyone out there know of a way to perform case-insensitive string matching
on character strings defined as indexes on an Oracle table?

I am a new user, and have so far read parts of the DBA guide, and the SQL*Plus
Users guide. As far as I know, you have to know how the indexed string value
was stored (upper or lower case), in order to get a match in  a query to the 
database table. Is this correct, or am I missing something? Are there any 
clever tricks one can use to overcome this problem?
-- 

	Preeti Mehta, GTE Labs., Waltham, MA
e-mail : pm04%gte-labs.csnet@relay.cs.net