[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