Xref: alice comp.databases.oracle:75659 comp.databases.oracle.misc:39579
Path: alice!news-feed.fnsi.net!netnews.com!news.maxwell.syr.edu!dispose.news.demon.net!demon!peernews!peer.news.bb.u-net.net!u-net!yama.mcc.ac.uk!not-for-mail
From: Stu <stu@dkmsoft.com>
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle,comp.database.oracle.misc,comp.database.oracle
Subject: Case Sensitivity in select
Date: Thu, 26 Aug 1999 12:28:42 +0100
Organization: Sirius Cybernetics Corporation
Message-ID: <37C524EA.CC828BE7@dkmsoft.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.61 [en] (WinNT; I)
X-Accept-Language: en
Lines: 4

Is it possible to set a parameter which will make a select statement
case insensitive. i.e. so that select * from words where word='hello'
will bring back records where word='HELLO' or 'Hello'.