Re: case insensitive searches

Randy Dewoolfson (randyd_at_cais2.cais.com) wrote:
: Anthony Sama (asama_at_netaxs.com) wrote:
 

: : What's the best way to specify case insensivity in a WHERE
: : clause?
 

: To match strings withou regard to case you might try
: WHERE UPPER( string1) = UPPER( string2 )
: or the LOWER equivalent..
 

: Hope it helps
: Randy :)

It is true that using upper or lower will provide a case insensitive search. However, if either string1 or string2 is a column name, then Oracle will have to do a sequential search on the table because it hase to change the column value to upper or lower case before doing the comparision. If the table is large this could be very slow. Carol Fetters
cfetters_at_iac.net Received on Sun Jul 23 1995 - 00:00:00 CEST