How to make all searches case-insensitive?

I would like all my searches to be case insensitive. Through my app, I have:

SELECT Column1 from Table WHERE Column2 = 'some_value'

I want the effect of:

SELECT Column1 from Table WHERE UPPER(Column2) = 'UPPER(some_value)'

I would like to do this globally if possible, as I have lots of code - even though
*most* of the SQL is not hardcoded.

Can I use a trigger, sp? Received on Tue Mar 21 2000 - 08:57:41 CST