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