I would like to query a database and return results from the database that match the first alphabetical letter. So for example, if on a web page I display the alphabet like so:
A B C D E (etc)...
When a user chooses a letter the query returns all the results that begin with that letter.
What is the best way to do this? Any ideas would be great.