Interested to Buy Any Domain ? << Click Here >> for more details...
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
How important do you consider cursors or while loops for a transactional database?
What is resultset concur_updatable?
what is raid? : Sql server database administration
How to remove duplicate rows from table except one?
What are alternate keys?
Why do we partition data?
What do you understand by mirroring?
What is sql view?
Is it possible to call a stored procedure within a stored procedure?
What are different types of schemas?
How do I save a stored procedure in sql server?
Can a table be created inside a trigger?
Where are sql server user names and passwords stored in sql server?
How network traffic be reduced by using the stored procedure?
What is merge join?
