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 are two difference between sql azure and azure tables?

139

Can you explain full-text query in sql server?

554

What is Extended user-defined?

546

is it important for a database administrator to understand the operating system and file access? : Sql server administration

592

What is bcnf normalization form?

672

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

519

What command would you use to create an index?

599

what types of replication are supported in sql server? : Sql server database administration

471

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

3767

What are the characteristics of modern DBMS?

629

How to modify an existing stored procedure in ms sql server?

541

What is the use of partition by in sql server?

517

Explain where clause?

539

Explain the first normal form(1nf)?

565

How do I get to sql server configuration manager?

527