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 are the exceptions handled in sql server programming?

1070

How to connect php with different port numbers?

1092

How to connect Azure federated root database and apply federation in entity framework?

107

Can sql server 2016 run on windows 7?

925

Explain cross join or cartesian product in sql?

896

Do you know what are the differences between lost updates and uncommitted dependencies?

1092

What are the dis_advantages of stored procedures, triggers, indexes?

2230

Do you know what is a linked server in sql server?

1032

can you implement data mining in SSRS?

151

When we should use and scope of @@identity?

1002

What is subreport?

144

How to delete a database in ms sql server?

1243

Explain rdbms?

1047

How to create a view on an existing table in ms sql server?

1136

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

891