[AccessD] Asterix

Tony Septav TSeptav at uniserve.com
Fri Feb 24 10:05:12 CST 2012


Hey Rocky
still might be interpreted as a wild card.
Yup that is what happens. 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Friday, February 24, 2012 7:58 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Asterix

Use the chr() function with the ASCII value of an *? Not sure that will work
though - still might be interpreted as a wild card.

R


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav
Sent: Friday, February 24, 2012 7: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



More information about the AccessD mailing list