select names starts with a,b,c
Answer Posted / naren
Lakshmi Narayanan u r correct.
But we can use the table only.
SELECT * FROM abc WHERE ename LIKE '[a-c]%'
I think its better...
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
How sql server executes a statement with nested subqueries?
what is memory-optimized nonclustered indexes
how to control the amount of free space in your index pages? : Sql server database administration
Why is replication required on the sql server?
What are the differences between having and where clause.
How to create view in stored procedure sql server?
What does top operator do?
Tell me what is the stuff and how does it differ from the replace function?
What is the difference between sdf and mdf?
What are the different types of sql server replication? : sql server replication
What is ssl in sql server?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
what is unique and xaml nonclustered index
What is replication and database mirroring?