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

What is multi-statement table-value user-defined function?

935

What are the general features of sql server management studio? : sql server management studio

1016

Why use view instead of a table?

879

What are the 10 characteristics of data quality?

899

Explain about remote stored procedure?

964

In which sql server version report builder introduced?

142

What is an index. What are the types?

1011

How do I install only the client tools of sql server 2000?

991

List out some of the requirements to set up a sql server failover cluster?

979

How to loop through returning rows?

972

What are joins in sql and what are the different types of joins?

962

Explain encryption of entire databases without the need for application changes in sql server 2008?

994

Do you know what is xpath?

1003

What is difference between drop truncate and delete?

1016

mention different types of relationships in the dbms?

962