In-case sensitive searches

From: Brian Rasmusson <br_at_belle.dk>
Date: 1997/09/18
Message-ID: <34212827.3839721A@belle.dk>#1/1

Hi,

what's the best way to perform an in-case sensitive search? Ofcourse SELECT x FROM y WHERE UPPER(z) = UPPER(mystr) is out of the question because it does not use the index.

Is there a way to specify to ignore case, or a way to create an uppercase index?

Best regards,
Brian

--


------------------------------------------------------------------------

Brian Rasmusson, Software engineer & analyst     e-mail: brianr_at_belle.dk
Belle Systems A/S                                web   : www.belle.dk
Network, Internet and communication specialists  phone : +45 59442500


------------------------------------------------------------------------

Received on Thu Sep 18 1997 - 00:00:00 CDT