Is there a command to make all string comparisions case-insinsitive?

I can't use the function: UPPER()

because the sql statement is hard coded in a third party email server.

Thank you,
-sl