I am using ODBC from Visual C++/MFC. I want to have filters and sorts that are case insensitive. For the filters I tried this: SELECT … WHERE upper(NAME) = upper('Jordan'); Apparently 'upper' is not implemented in ODBC. What is the proper way to have case insensitive text fields? — Jordan