[AccessD] Asterix

Benson, William (GE Global Research, consultant) Benson at ge.com
Fri Feb 24 16:57:14 CST 2012


Nope, only some of them!


Like "*[*]*"


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

This worked for me in a query to find values in a field with an asterisk in them

Like "*[*]"

On Fri, Feb 24, 2012 at 10:15 AM, Gary Kjos <garykjos at gmail.com> wrote:
> 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



--
Gary Kjos
garykjos at gmail.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list