String comparison "Like"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have some queries I created in Access2000 that worked like a champ ...
until I converted to 2003. The problem is the "Like" I was using - in 2003,
it became "Alike" and no longer functions correctly. What I had was:
If(stringA Like stringB*)
as a filter in the query. It no longer works. How can I get back the same
function I had - compare the string to another string with an asterisk
working as "who cares what follows"?
 
This might be a wrong option setting.

Make sure the box is unchecked under:
Tools | Options | Tables/Queries | SQL Server Compatible Syntax

(The ALike operator is designed to make Access work like SQL Server,
including using % as the wildcard.)
 
Back
Top