Re: Case Sensitivity Issue
From: David g <david_ng_at_mindlink.bc.ca>
Date: 1996/03/02
Message-ID: <4h8vg2$t7h_at_fountain.mindlink.net>#1/1
Date: 1996/03/02
Message-ID: <4h8vg2$t7h_at_fountain.mindlink.net>#1/1
Kee P Luk <keeluk_at_mit.edu> wrote:
>Does anyone know how to do case-insensitive string comparison of column
>fields in the where clause? Besides converting everything to either
>uppercase or lowercase in the where clause. Is there a parameter in
>Oracle I can use to do this so that I can still have the advantage of
>using indices on these columns?
>
>Thanks in advance
>Kee Luk
The answer is NO. Another option is to have new column to store the upper case value and have index on it.
David Received on Sat Mar 02 1996 - 00:00:00 CET