Tina Norris Fields
tinanfields at torchlake.com
Fri Feb 24 11:03:16 CST 2012
Hi Tony, The escape character that I found is the backslash - \ - I think that is supposed to say "treat the immediately following character as a literal character" So, I would expect it to look like this: \* I haven't tried to do what you are trying to do, so I will be watching to see what the solution turns out to be. Best, T Tina Norris Fields tinanfields at torchlake.com 231-322-2787 On 2/24/2012 11:48 AM, Tony Septav wrote: > Hey Tina > Thanks > Sorry but I do not understand what the escape character is that you are > referring to and therefore how to use it. > > Tony Septav > Nanaimo, BC > Canada > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tina Norris > Fields > Sent: Friday, February 24, 2012 8:45 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Asterix > > Hi Tony, > Well, lets see, won't the escape character \ take care of that? > What happens when you do that? > T > > Tina Norris Fields > tinanfields at torchlake.com > 231-322-2787 > > > On 2/24/2012 10:51 AM, Tony Septav wrote: >> 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 > ----- > No virus found in this message. > Checked by AVG - www.avg.com > Version: 2012.0.1913 / Virus Database: 2114/4829 - Release Date: 02/24/12 >