M MGFoster Apr 20, 2004 #2 Chen said: How can I escape characters in an Access query? Click to expand... -----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-----
Chen said: How can I escape characters in an Access query? Click to expand... -----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-----
