select names starts with a,b,c
Answer Posted / rajkumar v
SELECT * FROM TABLE_NAME WHERE Colum_Name LIKE '[a-c]%'
OR
SELECT * FROM TABLE_NAME WHERE Colum_Name LIKE '[a,b,c]%'
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is difference between count (*) and count column?
Explain primary key and foreign key constraints?
What is RMS migrations?
What is data source object?
what is the difference between openrowset and openquery?
what is a self join? : Sql server database administration
what is difference between view and Dip.
What does indexation mean?
Explain candidate key, alternate key, and composite key?
What are the different types of cursor?
Can a cursor be updated? If yes, how you can protect which columns are updated?
Explain tablesample?
How to create a simple user defined function in ms sql server?
What does it mean to normalize a database and why would you do it?
How to find the service pack installed? : sql server database administration