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.

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.

Can you inner join the same table?

0 Answers  

---

Explain the order of sql statement execution?

0 Answers  

---

what is sql profiler? : Sql dba

0 Answers  

---

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

0 Answers  

---

What are field types?

0 Answers  

---

how to include comments in sql statements? : Sql dba

0 Answers  

---

Is grant a ddl statement?

0 Answers  

---

Mention what is the plv (pl/vision) package offers?

0 Answers  

---

what are the forced views

6 Answers   Hexaware, TCS,

---

My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

2 Answers   CG,

---

who introduced sql?

0 Answers  

---

What is mutating trigger?How to avoid it??

3 Answers   Tech Mahindra,

---