[AccessD] Asterix

Hey Tina
Learned something new???????????
What a load of crap, I knew it all along but I forgot. That is what happens
when you become an old fart. Just kidding. Yup, you never stop learning and
that it is kind of nice.
Thanks to All.

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 10:25 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Asterix

Excellent - we both learned something today.  :-) T

Tina Norris Fields
tinanfields at torchlake.com
231-322-2787


On 2/24/2012 12:39 PM, Tony Septav wrote:
> 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
>
--
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