[AccessD] Asterix

Tony Septav TSeptav at uniserve.com
Fri Feb 24 11:39:18 CST 2012


Hey Lambert
Thanks kindly. 
Seems to be doing the trick. 
Last piece of the puzzle solved.

Tina you were kind of on the right track.
Found this (I like to understand what I am doing)
[] used to escape reserved keywords used as identifiers
Eg. SELECT [select] FROM test 

Tony Septav
Nanaimo, BC
Canada

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: Friday, February 24, 2012 9:00 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Asterix

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

--
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



More information about the AccessD mailing list