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