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

select names starts with a,b,c

Question Posted / gopinath

Answer Posted / gopinath

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

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the dbcc command and why is it used?

1064

How to enable/disable indexes?

1077

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1147

What is a non clustered primary key?

937

Mention the different types of replication in sql server.

1037

What are the different type of replication in sql server?

991

How to execute stored procedure in select statement sql server?

1071

Can we linked SharePoint to a SQL database?

1042

what are database files and filegroups? : Sql server database administration

954

What are the fixed server level roles? : sql server security

1145

What are the different types of locks in the database?

935

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1217

What is built-in/administrator?

1023

What is SQL Azure Fabric?

110

How to enter comments in transact-sql statements?

953