DaniWeb IT Discussion Community - Using Select Statement to retrieve data from SQL Server 2005 database

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)

- VB.NET (http://www.daniweb.com/forums/forum58.html)

- - Using Select Statement to retrieve data from SQL Server 2005 database (http://www.daniweb.com/forums/thread158886.html)

Ugochukwu

Nov 22nd, 2008 12:30 am

Using Select Statement to retrieve data from SQL Server 2005 database

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!

timothybard

Nov 22nd, 2008 6:23 pm

Re: Using Select Statement to retrieve data from SQL Server 2005 database

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

All times are GMT -4. The time now is 5:20 pm.