I have a sql statement:
SELECT AgentName FROM tblAgent WHERE AgentName LIKE '*Del*Dwy*' AND Region LIKE 'O*';
I run the sql in MS access as a query, it retrieves all Agents that match the above criteria. I have placed the same statement in VB when the users presses "Save", but finds NO records. Same database, same sql statement....
What am I missing? I have many sql statements that query the database but the only difference is I am using the LIKE option instead of the "=".