SELECT NAMES FROM TABLE_NAME WHERE lower(NAME) LIKE 'a%' or

select names starts with a,b,c

Question Posted / senthil

Answer Posted / senthil

SELECT NAMES FROM TABLE_NAME
WHERE lower(NAME) LIKE 'a%'
or lower(NAME) LIKE 'b%'
or lower(NAME) LIKE 'c%';

Is This Answer Correct ?

8 Yes

3 No

Please Help Members By Posting Answers For Below Questions

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

1156

What is apply operator in sql?

957

Do you know the cursor types?

1111

Explain different types of self contained sub query?

948

Why and when do stored procedure recompile?

928

What is the report builder?

131

Explain about Normalization?

1012

How do I find the port number for sql server?

921

How to insert and update data into a table with "insert" and "update" statements?

917

wat wil hapn if we give the both read and deny read permission to user?

2060

What are the difference between primary key and unique key? : sql server database administration

892

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1032

System variable and temporary variables

2183

How many types of local tables are there in sql server?

887

what does the automatic recovery do? : Sql server administration

958