Results 1 to 2 of 2

Thread: Wildcard search

  1. #1

    Thread Starter
    New Member
    Join Date
    Mar 2000
    Location
    Hampshire
    Posts
    1
    The db i have written needs to be able to search using
    wildcards
    e.g. *abc123
    allowing suffix and prefix searches.
    What is the code?!?!?!?

    I have recordset.findfirst code but i can't wildcard.
    Somebody pleez help.

  2. #2
    Member
    Join Date
    Oct 1999
    Location
    Snellville, GA, USA
    Posts
    38
    This is ADO Code, but it might work with DAO.

    rstMain.Find "FirstName like 'Elias*'"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width