select * from table_name where Name like 'A%' union select * fr

select names starts with a,b,c

Question Posted / naren

Answer Posted / naren

select * from table_name where Name like 'A%'
union
select * from table_name where Name like 'B%'
union
select * from table_name where Name like 'C%'

Is This Answer Correct ?

6 Yes

10 No

Please Help Members By Posting Answers For Below Questions

Does the order of columns in update statements matter?

672

What are information schema views?

745

How to create “dependant” parameter “make, model, year”

105

tell me the disaster recovery plan

2196

What is Sqlpaging in SqlServer 2005 ?

854

What is a deadlock and what is a live lock?

758

What are system databases into sql server (2005/2008) : sql server database administration

764

What are page splits?

764

What is rolap and its advantage? : sql server analysis services, ssas

946

What is a database in ms sql server?

741

What are the two authentication modes in sql server?

791

What is snapshot report?

136

why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration

786

How to manipulate data from one table to another table ?

724

How to create a stored procedure with a statement block in ms sql server?

754