[AccessD] Asterix

Heenan, Lambert Lambert.Heenan at chartisinsurance.com
Fri Feb 24 10:59:36 CST 2012


Gary provided the solution...

Like "*[*]"

Lambert 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav
Sent: Friday, February 24, 2012 11:49 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Asterix

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

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list