Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2008

    Unanswered: Query Contains search

    i want my query to search for for something that contain a key word e.g i have a collum that contains different full names like john smith etc. now i want it to bring up john smith even if i only type John into the search

  2. #2
    Join Date
    Jan 2007
    Provided Answers: 12
    Have a look at LIKE comparisons in the help files
    Home | Blog

  3. #3
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    thats going to be something like

    select comma, separated, list, of, columns from mytable
    where fullname like "John%"
    order by fullname;

    asuuming of course you have a column called fullname in your db
    you may need to change the % to a * so JET does the right wild card matching
    the wildcard indicates that any character may be appear here.. heck as Gerogev saya go have a look in the help file for wildcards
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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