I'm using mySQL with PHP and I'm looking to pull some VARCHAR data from a database. I have a listing on my site that pulls up information by first letter based on a link someone clicks. Example page.php?search=P The query is something like SELECT from DB WHERE field LIKE $search ORDER BY ASC I wanted to put a link so that I could pull out all the values that do not begin with a letter. The idea I had was to select all data from the table, list it ascending, and stop pulling data out when the names start beginning with a letter. I have the concepts in my head but I'm not sure how to put them into code. Anyone know what will get me goin in the right direction?