DataDirect Connect for ODBC User's Guide and Reference

last_name = ’Smith’
WHERE last_name = ’Smith’ and middle_name = ’Edward’ and
first_name = ’Thomas’
WHERE emp_id >= ’E10001’ AND last_name = ’Smith’