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
can a table be moved to different filegroup? : Sql server administration
what do you understand by change data capture?
What is check constraint in sql server?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
What is the purpose of update statistics and scope_identity() function?
What is table constraint?
Explain the steps to use transact-sql cursor?
What are subqueries in sql server?
What do you understand by physical_only option in dbcc checkdb?
Is null vs coalesce?
What is ms sql server triggers?
What is an indice?
Define Unique Key?
Can you name a few encryption mechanisms in sql server?
Write a sql query to display the current date?
