[AccessD] Asterix

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
>