Alphabetical search

gigicp · #1 02-09-2003, 03:57 AM

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!

skhanal · #2 02-09-2003, 09:18 AM

Try

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