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

R

Roger Profitt

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?
 
M

MGFoster

Roger said:
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?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

"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.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRDVJFIechKqOuFEgEQKGPACgwReq80ANiOuaIHkT//lckORX7fIAnjeX
fW8llNKO0WofEZeWSH7iBMFa
=Rw2U
-----END PGP SIGNATURE-----
 

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

Top