DataDirect Connect for ODBC User's Guide and Reference

SELECT * FROM emp WHERE last_name = ’Smith’
SELECT * FROM emp WHERE UPPER(last_name) = ’SMITH’
WHERE last_name = ’Smith’ and first_name = ’Thomas’