Answer Posted / rajendra prasad reddy penumall
'Like' operator is a pattren matching operator.
Eg;
select name from class where name like 'a%'
selecting names starting with letter 'a' and any length
select name from class where name like '_a%'
selecting names starting with second with letter 'a' and
any length.
select name from class where name like '[abc]%'
selecting names starting with first letter 'a'or 'b'
or 'c' and any length.
select name from class where name like '[^abc]%'
selecting names except starting with first letter with
letter 'a'or 'b' or 'c' and any length.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What are cursors stored procedures and triggers?
Explain syntax for dropping triggers?
What is use of @@ spid in sql server?
How to create a dynamic cursor with the dynamic option?
Difference between Logical Page and Physical Page in SSRS.
Do you know what is replace and stuff function in sql server?
What is precedence constraint?
When you should use a low fill factor?
Define candidate key, alternate key, and composite key.
Explain security with sql azure?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Can sql servers link to other servers like oracle?
Why SQL Agent is used?
How to loop through returning rows?
How to create function with parameter in sql server?