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 the advantages of user-defined functions over stored procedures in sql server?
What is the federation in sql azure?
What are the advantages of user defined function?
Why would you call update statistics?
What is page-level compression?
How you can add messages to the nt event log from within a stored procedure?
What are the disadvantages of indexes?
What is rank function?
Explain about remote stored procedure?
What Are the Main Features of SQL Azure?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
Do you know what is a with(nolock)?
What is an execution plan? When would you use it?
Explain following error properties?
How to receive output values from stored procedures?