select names starts with a,b,c

Answer Posted / lakshmi narayanan r

SELECT * FROM abc a WHERE a.ename LIKE '[a-c]%'

Is This Answer Correct ?    19 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

whats new about truncate in sql server 2008?

2024


What is fill factor and pad index?

538


What is sharding?

88


Explain user defined views?

573


after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

1683






What is faster join or union?

597


How to declare and use cursor variables?

579


What is the difference between inner join and equi join?

490


What is the difference between varchar and varchar types?

560


What is cursors?

636


Explain what are the authentication modes in sql server?

500


How to create a view with data from multiple tables?

557


What is the native system stored procedure to execute a command against all databases?

534


What are different type of Collation Sensitivity?

552


How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

677