Lakshmi Narayanan u r correct. But we can use the table only. SELECT *

select names starts with a,b,c

Question Posted / naren

8 Answers
14205 Views
Scope International, I also Faced
E-Mail Answers

Answer Posted / naren

Lakshmi Narayanan u r correct.
But we can use the table only.

SELECT * FROM abc WHERE ename LIKE '[a-c]%'

I think its better...

Is This Answer Correct ?

10 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are cursors in ms sql server?

1185

Why is the need for data conversion transformations?

1072

Tell me what is the significance of null value and why should we avoid permitting null values?

993

Can group by and orderby be used together?

1019

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

1120

What is similarity and difference between truncate and delete in sql?

1103

Explain the cursor lock types?

1061

Explain DBCC?

968

What is xdr?

996

What are the components of dbms?

954

What is a heap?

1042

Some queries related to SQL

986

What are the five major components of a dbms?

932

What is faster join or union?

1225

What protocol does sql server use?

949