What are all the difference between Like and Contains ?
Answer Posted / 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 View All Answers
How to download oracle sql developer?
what are the types of join and explain each? : Sql dba
Can you upgrade sql express to full sql?
What is the difference between the conventional and direct path loader? : aql loader
What is an inner join sql?
what is denormalization. : Sql dba
How do you modify a trigger?
What are commit, rollback, and savepoint?
What are the syntax and use of the coalesce function?
Is left join and outer join same?
how to use case expression? : Sql dba
Does sql profiler affect performance?
how to include comments in sql statements? : Sql dba
define join and explain different type of joins? : Sql dba
What is the difference between an inner join and an outer join?