Re: Searching case-insensitively

I haven't tried this but what about the SOUNDEX function??? Just 2 cents.

Rich

In <31e1078e.2086985_at_n5.gbso.net>, chuckh_at_dvol.com (Chuck Hamilton) writes:
>Simon Mercer <mercer_at_mpimg-berlin-dahlem.mpg.de> wrote:
>
>>Well, so far I know that if I use functions I can't use indices, and
>>that there is no other way to switch to a default case-insensitive
>>searching behaviour. Forcing text entry in uppercase is not an option
>>because case has meaning in these text strings.
>>
>>So there's no way to do this (unless someone knows different)....
>>
>>Surely this is a MASSIVE shortcoming in Oracle, or am I the first person
>>in the world who needs an efficient case-insensitive search?
>
>One possible solution, though not a very elegant one, is to create an
>upper case name column in addition to the mixed case one and index
>that.
>
>That's the only thing I can think of till oracle either gives us the
>option of a case insensitive b-tree algorithm, or indexed computed
>columns.
>--
>Chuck Hamilton
>chuckh_at_dvol.com
>
>Never share a foxhole with anyone braver than yourself!
>
Received on Wed Jul 10 1996 - 00:00:00 CEST