Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Posts
    85

    Talking Unanswered: run a query with the first letter of a name

    i have a query run that shows an entire record by the user entering in one field how can i get lets say ... all the fields that start with the letter B is it like *B or something

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Lightbulb

    PHP Code:
      SELECT YourTable.yourField
        FROM YourTable
        WHERE YourTable
    .yourField  Like "B*" 

Posting Permissions

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