I am searching a database of names and I would like to do this alphabetically. So far everything is working well except that I need to have it match the first letter in the names. Here's an example:<BR><BR>If i click on "G" it will run through the database and return a list like the following (excuse the names :) ):<BR><BR>Gertrude<BR>Egbert<BR>Angela<BR>etc...<B R><BR>It is finding every name that has "G" in it. How can I limit the search to the first letter? My WHERE clause is:<BR><BR><BR>searchstr = Request.querystring("letter")<BR><BR>"SELECT blah FROM blah<BR>WHERE (DATEDIFF(day,getdate(),People.ExpiryDate) => 0) AND People.ClubID = '" + Session("ClubID") + "' AND People.LastName LIKE '%" & searchstr & "%' <BR>ORDER BY blah, blah "<BR><BR>Thanks in advance.