Interested to Buy Any Domain ? << Click Here >> for more details...
What are all the difference between Like and Contains ?
- 2 Answers
- 10717 Views
- LG Soft, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is dcl in sql?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
Explain the difference between 'between' & 'and' operators in sql
What is difference between nchar and nvarchar?
Can you upgrade sql express to full sql?
What is parameter substitution in sql?
Which is faster view or stored procedure?
What does <> sql mean?
Define union, minus, union all, intersect ?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
How do I copy a table in sql?
What are pl sql data types?
What are different methods to trace the pl/sql code?
What is an index in sql with example?
Show code of a cursor for loop.
