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

How extra digits are handled with numeric data type literals?

974

What is page in sql server?

954

Explain nested trigger in sql?

1088

What are policy management terms?

992

What is a scheduled job or what is a scheduled task?

952

How to create a store procedure with encryption?

1012

What is subquery explain with example?

1068

What is compression - row-level and page-level compression?

922

How do I debug a stored procedure in sql server?

1118

Define inner join? Explain with an example?

1006

Explain about nested stored procedure?

1041

What is exporting utility?

1031

In what three ways is the return statement used in a stored procedure?

1016

What to perform pattern match with the like operator?

889

What is the difference between a clustered index and a non-clustered index?

993