Benson, William (GE Global Research, consultant)
Benson at ge.com
Fri Feb 24 16:57:14 CST 2012
Nope, only some of them! Like "*[*]*" -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gary Kjos Sent: Friday, February 24, 2012 11:19 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Asterix 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com