ADO, Access 97 & 'LIKE' in Whereclause
Posted on 1999-11-08
I pass a simple select statement to the open method of an ADO recordset and it fails to return any records. The SQL Statement is:
SELECT * FROM CLIENT
WHERE LAST_NAME LIKE "SMI*"
If I paste this statement into the SQL design window in Access 97, it returns the appropriate # of recs. All other SQL statement types that I have used that did not include "LIKE" in the Whereclause return the appropriate # of recs.