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!