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