Why does the like operator keep changing to alike in my queries?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roger Profitt - 06 Apr 2006 17:02 GMT

Whenever I use the "Not Like" operator in a query Access changes it to "Not
ALike" which doesn't work! Does anyone know how to stop it from doing this or
what the cause of it is?

Reply to this Message

MGFoster - 06 Apr 2006 18:00 GMT

> Whenever I use the "Not Like" operator in a query Access changes it to "Not
> ALike" which doesn't work! Does anyone know how to stop it from doing this or
> what the cause of it is?

"ALike" = ANSI Like. Which means it is using the ANSI wildcard
characters % and _ instead of the Access (JET) wildcard characters * and
?, respectively.

When you're working in an .adp file ANSI is the default 'cuz the front
end (the .adp file) is connecting to SQL Server, which uses the ANSI
wildcard characters.

When working in a .mdb file, if the ANSI 92 syntax feature is selected
then the ALike will be substituted for Like to indicate that the ANSI
wildcard characters are to be used.

Signature

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Reply to this Message