Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2005
    Posts
    25

    Unanswered: Query Help Needed

    I want to have a Query which can search on part of a given criteria.

    like, when the full name is micheal something , if you type micheal or mic , it will find it.

    Now i have

    SELECT Full Name
    FROM User-id
    WHERE Full Name LIKE [Geef Gewenste Criteria op]

    what should I add to this?

  2. #2
    Join Date
    Sep 2003
    Location
    Birmingham, UK
    Posts
    121
    Try something like
    SELECT Full Name
    FROM User-id
    WHERE Full Name LIKE '*Geef Gewenste Criteria op*'

  3. #3
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    Probably your after this instead

    Code:
    SELECT Full Name
    FROM User-id
    WHERE Full Name LIKE [Geef Gewenste Criteria op] & "*";
    as i presume [Geef Gewenste Criteria op] is a parameter

  4. #4
    Join Date
    Feb 2005
    Posts
    25
    with this I don't get a messagebox where I can give up what I'm searching for.
    It just gives a blank result

  5. #5
    Join Date
    Feb 2005
    Posts
    25
    Quote Originally Posted by DavidCoutts
    Probably your after this instead

    Code:
    SELECT Full Name
    FROM User-id
    WHERE Full Name LIKE [Geef Gewenste Criteria op] & "*";
    as i presume [Geef Gewenste Criteria op] is a parameter
    This works. Thanks so much!

Posting Permissions

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