Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Search for the literal * (asterick)

Discussion in 'Information Technology' started by Emmy, Jul 28, 2006.

  1. Emmy

    Emmy
    Expand Collapse
    Guest

    I have a field that I would like to search for the literal *(asterick). It
    would need to find the following:

    Example: A-100* CA

    Is there a way to search using the * before and after the criteria with the
    criteria being "*"?

    Thanks!!
    Emmy
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News Indian American Couple Donates For Sikh, Punjabi Culture Research In US Breaking News Aug 19, 2016
    Soul Search By Swarn Singh Bains Book Reviews & Editorials May 25, 2016
    Harpal Singh Kumar Cancer Researcher Knighted By Queen Elizabeth II Sikh Personalities Jan 5, 2016
    Movies Ashdoc's Movie Review---dozakh In Search Of Heaven ( 2015 ) Theatre, Movies & Cinema Apr 6, 2015
    Research Shows NFL Quarterbacks Play Better With Beards Business, Lifestyle & Leisure Nov 23, 2014

  3. Wayne-in-Manchester

    Wayne-in-Manchester
    Expand Collapse
    Guest

    * is used by access to denote muliplication so you have a problem with using
    it within text unless you place the data within " " to let the programme know
    it's text. You can then search on it as you would anything else.

    Try using Like "*"

    Hope this helps



    "Emmy" wrote:

    > I have a field that I would like to search for the literal *(asterick). It
    > would need to find the following:
    >
    > Example: A-100* CA
    >
    > Is there a way to search using the * before and after the criteria with the
    > criteria being "*"?
    >
    > Thanks!!
    > Emmy
     
  4. Rick B

    Rick B
    Expand Collapse
    Guest

    This was just answered in the last week or so. Do a search and read that
    post.

    I think it was something like...

    Like ^*

    or

    Like "*^"

    Or Like "^"



    --
    Rick B



    "Emmy" <Emmy@discussions.microsoft.com> wrote in message
    news:0FF93E2A-9625-424D-8294-432D09573C1F@microsoft.com...
    >I have a field that I would like to search for the literal *(asterick). It
    > would need to find the following:
    >
    > Example: A-100* CA
    >
    > Is there a way to search using the * before and after the criteria with
    > the
    > criteria being "*"?
    >
    > Thanks!!
    > Emmy
     
  5. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    LIKE "*[*]*"

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no private e-mails, please)


    "Emmy" <Emmy@discussions.microsoft.com> wrote in message
    news:0FF93E2A-9625-424D-8294-432D09573C1F@microsoft.com...
    >I have a field that I would like to search for the literal *(asterick). It
    > would need to find the following:
    >
    > Example: A-100* CA
    >
    > Is there a way to search using the * before and after the criteria with
    > the
    > criteria being "*"?
    >
    > Thanks!!
    > Emmy
     

Share This Page