Rocky Smolin
rockysmolin at bchacc.com
Fri Feb 24 09:58:12 CST 2012
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