SELECT * FROM TABLE_NAME WHERE Colum_Name LIKE '[a-c]%' OR SEL

select names starts with a,b,c

Question Posted / rajkumar v

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

Please Help Members By Posting Answers For Below Questions

What is difference between count (*) and count column?

903

Explain primary key and foreign key constraints?

1031

What is RMS migrations?

2133

What is data source object?

999

what is the difference between openrowset and openquery?

1087

what is a self join? : Sql server database administration

1038

what is difference between view and Dip.

2409

What does indexation mean?

973

Explain candidate key, alternate key, and composite key?

1003

What are the different types of cursor?

1096

Can a cursor be updated? If yes, how you can protect which columns are updated?

1110

Explain tablesample?

995

How to create a simple user defined function in ms sql server?

1020

What does it mean to normalize a database and why would you do it?

979

How to find the service pack installed? : sql server database administration

1023