Re: How do I search for an asterick?

Tech-Archive recommends: Speed Up your PC by fixing your registry

Try looking for Chr(42), which is the asterisk.

HTH

brett wrote:
>I am trying to search for a literal asterick using a Query. Access assumes
>that I am using the asterick as a wildcard charactor and returns everything.
>What is the correct delimiter so that I can find the asterick?

--
Sam

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200601/1
.

Relevant Pages

  • Re: Problem running query from web using asterick
    ... The backend datasource is Access and the query ... using an asterick from an ASP web page. ... "Jeff Boyce" wrote: ... the SQL-Server wildcard instead of the wildcard you would use from ...
    (microsoft.public.access.queries)
  • Re: Access error message
    ... > create query using all catagories in table. ... > asterick and them try to run query it tells me I can't set criteria ... asterisk after it then you cannot place criteria in that same column of the ... query grid. ...
    (microsoft.public.access.queries)
  • Re: convert query to query
    ... >I used the asterick of the table from which I want the records deleted. ... *you* can see the query; ... FROM TableA Inner Join TableB ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: How do I search for an asterick?
    ... If the asterisk is not in a string but is the entire string ... When you need to search for wildcard characters using LIKE you can have them ... >I am trying to search for a literal asterick using a Query. ...
    (microsoft.public.access.queries)