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

Can we join two tables without primary key?

1095

What are different types of collation sensitivity?

1025

What is resource governor in sql server?

1049

What is ms sql server index?

1152

What are the disadvantages of using querystrings to send data from one page to another?

1073

System requirements for sql server 2005 express edition?

1070

What languages bi uses to achieve the goal?

1052

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1001

can you implement data mining in SSRS?

157

What is the recovery model?

1061

How can we remove orphan records from a table?

1031

What is onf in normalization form?

1111

What is difference between primary key and foreign key?

953

What is dml command?

1020

What are the differences between left join and inner join in sql server?

1157