Answer / 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.

Answer / deepak

Pattern matching is used to get the information without
mentioning the full name and by just using the LIKE operator
and just mention the starting letter.

what is index seek and index scan?

2 Answers  

---

What are group functions in query statements in ms sql server?

0 Answers  

---

what is the Ticketing tool used in Wipro technologies at Bangalore...???

0 Answers   Liquid Hub,

---

What is cdc in sql server?

0 Answers  

---

How to use clusters?

0 Answers   Amdocs,

---

Does union all remove duplicates?

0 Answers  

---

WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...

2 Answers   TVS,

---

How many types of Outer Joins?What are they?

1 Answers  

---

How to see the event list of an existing trigger using sys.trigger_events?

0 Answers  

---

What is merge join?

0 Answers  

---

What is the difference between UNION and UNIONALL?

5 Answers   CarrizalSoft Technologies, CTS,

---

What do you understand by mirroring?

0 Answers  

---