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
Explain iaas, paas and saas?
Define cross join in sql server joins?
What new changes are being made in SQL Server?
What is db stored procedure?
How to enter comments in transact-sql statements?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
Differentiate between delete and truncate.
What are the new features of sql server 2012 reporting service?
How do you start single user mode in clustered installations?
Why should you use or avoid select * statements?
What is user defined datatypes and when you should go for them?
What are the advantages of using stored procedures in sql server?
What is cursors?
