[AccessD] Asterix

Kaup, Chester Chester_Kaup at kindermorgan.com
Fri Feb 24 10:16:09 CST 2012


In the criteria use[*]. This also works for other wild cards such as # and ?

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav
Sent: Friday, February 24, 2012 9:51 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Asterix

Hey All
Does anyone know how do you search for an * in a string using SQL. I have
got it working for & and " but the * has got me stumped.
 
Thanks
Tony Septav
Nanaimo, BC
Canada
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list