When querying for character data using SQL, case matters. That is, “A” is not equal to “a”. The case of the search string may not match that of the data stored in your database. Even so, you might want to find all matches, whether uppercase, lowercase, or mixed case. If you use ODBC, the IBM i driver offers case-insensitivity via several keywords, as shown below. For testing, I’ll use the sample table QIWS.QCUSTCDT. It contains a column called CITY that includes a mixed case value ‘Dallas’. I can test using the standard isql command, specifying my default ODBC Data Source…
The post Case-Insensitive Queries using ODBC on IBM i appeared first on Seiden Group.
