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.
 
Back
Top