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

SQL Server Architecture ?

1923

How to display a past time in days, hours and minutes?

568

What is a dataset and what are the different types of datasets?

What are the different types of cursor?

603

What is msdb database? : SQL Server Architecture

534

How can you list all the columns in a database?

531

How we create SQL Server 2005 Reporting Services ? Give me Sample

1571

Explain triggers?

557

What is the difference between char, varchar and nvarchar?

568

What is the dbcc command and why is it used?

569

What are the difference between primary key and unique key? : sql server database administration

523

After removing a table from database, what other related objects have to be dropped explicitly?

553

Explain about protocol layer present in SQL server?

609

Explain different backup plans?

529

What is an index in a database?

531