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

select names starts with a,b,c

Question Posted / prashant

Answer Posted / prashant

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

Is This Answer Correct ?

16 Yes

6 No

Please Help Members By Posting Answers For Below Questions

How to drop an existing user defined function in ms sql server?

1063

What are the characteristics of modern DBMS?

1140

What is nonclustered index with included columns ?

1014

Is it important for a database administrator to understand the operating system and file access?

1041

Can I disable or restrict ssrs export formats (rendering formats)?

155

What are the components of sql server service broker?

1060

Why is normalisation important?

989

What are the properties and different types of sub-queries?

1050

What is a rollup clause?

1016

Can binary strings be converted into numeric or float data types?

1094

What does the on delete cascade option do?

1062

Can select statements be used on views in ms sql server?

1105

What is query and its types?

954

What is sql server database?

1078

How to modify the underlying query of an existing view?

1027