Results 1 to 4 of 4

Thread: Begins with

  1. #1
    Join Date
    Jul 2004
    Posts
    6

    Question Unanswered: Begins with

    How do I search for text that begins with "a"?
    Thanks

  2. #2
    Join Date
    Jul 2001
    Location
    NC
    Posts
    102
    Use the "%" wildcard, and WHERE <fieldname> LIKE clause in SQL statement. If you put the wildcard after the letter you are searching for, the letter will be first. If you put the wildcard before the letter, it will be the last letter. If you put the wildcard before and after the letter, it will look for it anywhere in that field.

  3. #3
    Join Date
    Jul 2004
    Posts
    6
    Quote Originally Posted by vududoc
    Use the "%" wildcard, and WHERE <fieldname> LIKE clause in SQL statement. If you put the wildcard after the letter you are searching for, the letter will be first. If you put the wildcard before the letter, it will be the last letter. If you put the wildcard before and after the letter, it will look for it anywhere in that field.
    Vududoc, Thanks for the help - it get exectly what I needed. Based ont his question, how would I search for titles that do not begin with letters, but do begin with numbers or other character?
    Thanks

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'd use NOT LIKE to exclude rows that match a pattern.

    -PatP

Posting Permissions

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