[AccessD] Asterix

Enclose the asterisk in square brackets?

http://office.microsoft.com/en-us/access-help/find-wildcard-characters-in-an-access-database-HA001171536.aspx

GK

On Fri, Feb 24, 2012 at 10:05 AM, Tony Septav <TSeptav at uniserve.com> wrote:
> Hey Rocky
> still might be interpreted as a wild card.
> Yup that is what happens.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
> Sent: Friday, February 24, 2012 7:58 AM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Asterix
>
> Use the chr() function with the ASCII value of an *? Not sure that will work
> though - still might be interpreted as a wild card.
>
> R
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Tony Septav
> Sent: Friday, February 24, 2012 7: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
>
> --
> 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/4828 - Release Date: 02/23/12
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



-- 
Gary Kjos
garykjos at gmail.com