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

Can we do dml on views?

914

Which Model uses the SET concept

933

What happens if the update subquery returns multiple rows in ms sql server?

1056

What is indexing a document?

968

How you can minimize the deadlock situation?

979

How to download and install microsoft sql server management studio express?

974

Does full backup break log chain?

911

how would you store your query in an SSRS report or a Database server?

152

Do you think BCNF is better than 2NF & 3NF? Why?

1226

What is row_number () and partition by in sql server?

1003

You are doing log shipping due to some reasons it is failing. How you will proceed from there

2017

How do I perform an unattended install of sql server 2000?

1018

you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation

893

Do you know what is similarity and difference between truncate and delete in sql?

958

How can you check the level of fragmentation on a table?

986