Chen said:
How can I escape characters in an Access query?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I'm assuming you mean in the WHERE clause?
WHERE ColumnName Like "[*]*"
This will find records that have an asterisk (*) at the beginning of the
string stored in ColumnName.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQIWdS4echKqOuFEgEQLUQgCdFCoIbiNX9oVJeuLAr9FOTWiSFoEAn0EI
KkKAY+9kR7TvtbIxLwm9+O15
=kO1i
-----END PGP SIGNATURE-----
