Re: Help! Case Insensitivity with SELECT..WHERE..LIKE queries

You could construct a query like

select * from table
where upper(fieldx) = upper(inputx);

one problem with this however is that using the upper function on the field side of the query will prevent the use of any indexes you may have on that field.
If possible, try to ensure that all data is stored in upper case either at the application level or by using a trigger and then you can safely code;

select * from table
where fieldx = upper(inputx);

and still be using indexes to speed up the access.

Ian Received on Mon Sep 01 1997 - 00:00:00 CDT