Ignore Case

I'm trying to get a selct to ignore case and thought the select below would return Joe or joe or any other combination that might be stored in the field, but isn't. Any idea what I'm doing wrong?

SELECT *
FROM CSADMIN.CLIENTS
WHERE UPPER (CSADMIN.CLIENTS.NAME) LIKE UPPER ('%joe%')

Thanks!

Mike Received on Wed Feb 26 2003 - 02:48:23 CET