SELECT NAMES FROM TABLE_NAME WHERE NAME LIKE 'a%' or NAME

select names starts with a,b,c

Question Posted / prashant

Answer Posted / prashant

SELECT NAMES FROM TABLE_NAME
WHERE NAME LIKE 'a%'
or NAME LIKE 'b%'
or NAME LIKE 'c%'

Is This Answer Correct ?

16 Yes

6 No

Please Help Members By Posting Answers For Below Questions

Difference between connected and disconnected database in .net with sql server?

1104

Why it is recommended to avoid referencing a floating point column in the where clause?

972

What is transactional replication?

973

When does a workload on SQL Azure get throttled?

131

What type of locking occurs during the snapshot generation? : sql server replication

1338

What is sql service broker?

990

Do you know nested transaction?

964

Explain Geometry datatype in sql server 2008 with example

998

How to handle error or exception in sql?

987

What is a rownum?

983

How do you handle datasets larger than 50 gb?

162

How to create and drop temp table in sql server?

1060

What does asynchronous call backs means?

1164

What is inline variable assignment?

1035

What is the command dbcc checkdb used for?

1016