[AccessD] Asterix

Hey All
Sorry guys, Gary and Chester.
For some reason I have just got your Emails.
I thank both of you very much for your input 

Tony Septav
Nanaimo, BC
Canada

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester
Sent: Friday, February 24, 2012 8:16 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Asterix

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


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.1913 / Virus Database: 2114/4828 - Release Date: 02/23/12