Help!!On how to code A-Z title search, PLEEEAASE!

<i><b>Originally posted by : Trinity (the_matrix_ad@hotmail.com)</b></i><br />To anyone out there, I really need some help for my school project, on how to code an <br />A-Z title link search.<br />For example: if the user clicks on C, it will take he/she to a page with all the movies starting<br />with the letter C.<br />I need to see what the SQL query would look like for this type of search.<br />My html file will have something like this...<br /><br /><b>View showtimes for movie titles that begin with:</b><br><br /> <a HREF="title_search.asp#A">A</a> <br /> <a HREF="title_search.asp#B">B</a> <br /> <a HREF="title_search.asp#C">C</a> <br /> .<br /> .<br /> .<br /> <a HREF="title_search.asp#Z">Z</a><br />I got this little code of some web site. I've just started learning ASP on the side, therefore I'm not <br />very familiar with it.<br />I do not understand why they're using the '#' in the HREF.<br />I have successfully built in a little ASP prototype that selects all the movie title from <br />my database. But the question is now, how to do this particular feature A-Z ????<br /><br />Thank you for taking your time to ready my humble help message.<br />I would reaaaally appreciate if anybody could help on this ASAP.<br /><br />Thaks again <br /><br />Trinity )<br />