[AccessD] Asterix

Well it found both of mine. Granted they were 1) the only thing in the
and 2) at the end of the field.

You did catch me on the embedded and leading ones. ;-)

GK

On Fri, Feb 24, 2012 at 4:57 PM, Benson, William (GE Global Research,
consultant) <Benson at ge.com> wrote:
> 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



-- 
Gary Kjos
garykjos at gmail.com