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