Re: Question on Case-insensitive queries
From: S. RAMAKRISHNAN <ram_at_jupiter.corp.sgi.com>
Date: Tue, 13 Jul 1993 01:58:25 GMT
Message-ID: <CA2ytE.GB0_at_odin.corp.sgi.com>
Date: Tue, 13 Jul 1993 01:58:25 GMT
Message-ID: <CA2ytE.GB0_at_odin.corp.sgi.com>
--In article HIA_at_isst.fhg.de, umatz_at_isst.fhg.de (Udo Matzinger) writes:
>Sudhakar Bhagavatula (sab3_at_Ra.MsState.Edu) wrote:
>: 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 >>
>
of course, upper() and lower() are solutions that have been posted already. but if the queries are being made in SQL*PLUS, one could use "set sqlcase upper" or "set sqlcase lower" as the case (no pun intended !) may be. by default, sqlcase is set to "mixed".
ram Received on Tue Jul 13 1993 - 03:58:25 CEST