Getting ALike instead of Like

[Giem]

Maybe I'm just not awake yet, but I don't ever remember typing - Like "RMA*"
- as a criteria in a query builder window and seeing Access change it to
ALike. And that is with a capital L. The only thing I did recently was
reinstall Visual C++.

I'm using it in a statement for a lookup from another table into a combo
box. The other day it worked fine. Now nothing shows up in the combo.

This is what the builder is outputting;all I'm trying to do is select the
field with the criteria that the record is like "RMA*":

SELECT JOBS.JOBNO FROM JOBS WHERE (((JOBS.JOBNO) ALike "RMA*"));

I'm newish, but I've never seen this before and I've never seen Access
change Like to ALike, ever. *Scratches head*

Anyone know what this is about?

 

[Giem]

Nevermind. I happen to come across the answer. The Database was set to ASNI
92 SQL mode. I think someone else who has access to this database is messing
with it.
In case someone comes across this in the future and it helps: You go to the
Tools Menu => Options... => Tables/Queries Tab. It's a check box to turn this

 

[Gary Walter]

Hi Giem,

Uncheck the SQL Server Compatible Syntax(Ansi92) in the
option for the dB.

Tools/Options/Queries tab/ This Database checkbox

good luck,

gary