Re: Question on Case-insensitive queries

In article <210cl9$883_at_Tut.MsState.Edu>, sab3_at_Ra.MsState.Edu (Sudhakar Bhagavatula) writes:
|> Hi,
|> Could someone please tell the method to perform Case-insensitive
|> queries. Please send me an e-mail to:
|> sudhakar_at_cs.msstate.edu
|>
|> Thanks in advance.
|>
|> --Sudhakar.
|>
|> --
|> << Sudhakar >>
|>

In SQL*PLUS you simply force everything to the same case:

             where upper(column_name) = 'STRING'

This does prevent the use of an index on the column. For SQL*FORMS, see the Advanced Forms Techniques manual; a very handy book. It describes how to perform case insensitive queries in detail.

                                 Ian MacGregor
                                 Stanford Linear Accelerator Center
                                 (415) 926-3528