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 to defragment indexes with alter index ... Reorganize?
What are scalar functions?
Can you explain different types of locks in sql server?
What is the downside of using udf?
Can you always create a cache of a report?
How to Update from select query in sql server?
How can I create a report based on a query? : sql server management studio
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Explain nested join?
what changed between the previous version of sql server and the current version? : Sql server database administration
How to enter binary string literals in ms sql server?
How to reaname table name without using sp_Rename in sql server..?
Explain few examples of stored procedure over triggers?
In what sequence sql statement is processed?
List the ways in which dynamic sql can be executed?
