Need a Query
I need a small query. In the table i am having different names among those i would like to display only the names that start with a particular letter.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Suchit KhannaPosted May 26, 2009, 7:43 AM
You could use the query as : SELECT Column_Name from table_name Where Column_Name LIKE '[char]%';
For eg if you want to find names starting with character 'D' in a table Employee having column FirstName:
SELECT FirstName from Employee WHERE FirstName LIKE 'D%';