What are all the difference between Like and Contains ?

Question Posted / mallikkannandevi

2 Answers
9795 Views
LG Soft, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are all the difference between Like and Contains ?..

Answer / rubyna

Like gives additional option of specifying exact
string/character position in the text. eg. if we want to
search all words having second letter 'a', we can use like,
but cannot use contain-

select * from emp where emp.name like '_a%'.

We don't have corresponding statement with contains.

Is This Answer Correct ?

4 Yes

0 No

What are all the difference between Like and Contains ?..

Answer / santosh acharya

Select * from myTable where textField like '%Cats and Dogs%'

Select * from myTable where CONTAINS(textField, '"Cats and
Dogs"')

Both options will only return rows that contain the exact
phrase "Cats and Dogs", neither will return records that
contain either "Cats" or "Dogs" in them.

Is This Answer Correct ?

2 Yes

6 No

Post New Answer