[AccessD] Asterix

Hey John
I just want to find all the records that contain an *.
But using an * in the Like string with the wild card finds all the records
In fact it returns "**"
Tony Septav
Nanaimo, BC
Canada
 

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

I think you have to use "like" instead of the math "equal" sign.

Where MyField like "*Colby"

Something like that.

John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

On 2/24/2012 11:16 AM, Kaup, Chester wrote:
> In the criteria use[*]. This also works for other wild cards such as # and
?
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav
> Sent: Friday, February 24, 2012 9:51 AM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Asterix
>
> 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