select names starts with a,b,c
- 8 Answers
- 11830 Views
- Scope International, I also Faced
- E-Mail Answers
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 changed between the previous version of sql server and the current version? : Sql server database administration
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
What is create statement?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
Can we delete data from a view?
What is an index in sql?
What are scalar functions in sql?
Can an entity have two primary keys?
What do you mean by an execution plan? Why is it used?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What is the main purpose of having conversation group?
Which tools are available to manage SQL Azure databases and servers?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How to use values from other tables in update statements in ms sql server?
How to specify the collation for a character data type in ms sql server?
