Why does query convert "Like" criteria to "ALike"

  • Thread starter Thread starter dishrag86
  • Start date Start date
D

dishrag86

Sometimes queries seem to go corrupt and when I type "Like" (without quotes)
into my criteria as soon as I click out of that criteria, it changes to
"ALike". Any ideas?
 
Uncheck the option to use "SQL Server Compatible syntax."

In Office 2007, click the Office button (top left) and then Access Options
(bottom of dialog.)

In earlier versions, it's Tools | Options.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Criteria Like 2
Getting ALike instead of Like 2
What does "Alike" in the filter criteria mean? 1
Query criteria - the Like operator 5
Alike operator replacing Like; I don't know why or how to fix 1
Alike 2
Like Converts to ALike in Query 2
Why does the like operator keep changing to alike in my queries? 1

Back
Top