Please friends am working on a project in which am trying to make it possible that when the first letter/alphabet of a name is keyed into a textbox linked to a search button and when the search button is pressed, all the names/rows begining with that first letter will appear in the Data Gridview provided for it.
Please i need the right SQL Select command statement to achieve this.You can also email me to brunosollozo42006@yahoo.com.Thank you!

You will need to use the LIKE operator with the % wildcard. There's more information here:
http://www.techonthenet.com/sql/like.php