Using Select Statement to retrieve data from SQL Server 2005 database

Expand Post »

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!

Similar Threads

Not getting information from the database in PHP
Fatal error: require once in PHP

Ugochukwu

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Nov 2008

Permalink

Nov 22nd, 2008

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

timothybard

Reputation Points: 27

Solved Threads: 29

Posting Whiz

Offline

317 posts
since Mar 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: Getting the sum and average help!

Next Thread in VB.NET Forum Timeline: help with array please

DaniWeb Message

Cancel Changes

User Name
Password