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 do you understand by sql server agent?
Which is the latest version of sql server and when it is released?
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
What does <> symbol mean?
Does an index slow down updates on indexed columns?
Is there any difference between primary key and unique with the not null condition?
What happens if null values are involved in comparison operations?
How to declare and use cursor variables?
How do indexes help, types?
what data regions are and what are the different data regions?
tell me the disaster recovery plan
How to write a query with a right outer join in ms sql server?
Write a query for primary key constraint with identity key word?
What security features are available for stored procedure?
Do you know what is a linked server in sql server?