Re: How to turn off case sensitive searches

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Tue, 14 Sep 1999 14:17:31 GMT
Message-ID: <37DE58FB.437222DE@edcmail.cr.usgs.gov>

You can't. The best you can do is use the UPPER or LOWER functions in your search.
For example:

SELECT * FROM TABLE WHERE UPPER(searchstring) = UPPER(column); (or LOWER) This will convert the column values and the search string to upper (or lower) case. Unfortunately, this will also suppress your indexes and make your query potentially run longer; unless you are using Oracle 8i where you can make a function based index.

HTH,
Brian

BJones8888 wrote:
>
> This should be an easy one for someone: How do I turn off the Oracle default
> of case sensitive searches?
>
> Bob Jones
> Omni Developments, Inc. --- (Custom Software Development)
Received on Tue Sep 14 1999 - 09:17:31 CDT