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