Results 1 to 2 of 2

Thread: Alphabetical search

  1. #1
    Join Date
    Feb 2003
    Location
    Canada
    Posts
    3

    Question Alphabetical search

    I have one question about the alphabetical search, I have written a SQL
    "SELECT * FROM name where firstname like 'A%'" to show all the name which are start from A.
    If I want to search from A to Z, do I need to write 26 SQL statements to do that or do I have another better methods to do that, anyone can help me to solve this problem.
    Thx!

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Try

    SELECT * FROM name where firstname like '[A-Z]%'

Posting Permissions

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