Gary Kjos
garykjos at gmail.com
Fri Feb 24 10:18:45 CST 2012
This worked for me in a query to find values in a field with an asterisk in them Like "*[*]" On Fri, Feb 24, 2012 at 10:15 AM, Gary Kjos <garykjos at gmail.com> wrote: > Enclose the asterisk in square brackets? > > http://office.microsoft.com/en-us/access-help/find-wildcard-characters-in-an-access-database-HA001171536.aspx > > GK > > On Fri, Feb 24, 2012 at 10:05 AM, Tony Septav <TSeptav at uniserve.com> wrote: >> 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 >> >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com > > > > -- > Gary Kjos > garykjos at gmail.com -- Gary Kjos garykjos at gmail.com