Problems in using Contains clause [message #233800] |
Fri, 27 April 2007 09:02 |
Rashmi_Katariya
Messages: 9 Registered: April 2007
|
Junior Member |
|
|
Hi All,
I have table with search_text field of CLOB datatype. iam using contains clause to search text in that field. most of the time the contains clause works. however, there are few phrases where my contains clause is not returning me the row, inspite of the row being available. my query is as follows :
Select contract_id,search_text
From scd_contract_detail
Where contains(search_text,'About the client',1) >0;
This particular phrase, "About the client" is not being searched in he field by cotains clause. Preveiously i had an issue with "on-demand" phrase which was solved by using curly brackets like "{on-demand}. but "about the client" phrase not working still. is there any problem with the phrase?
can there not be any generic method that will take care of all types of phrases?like using curly braces etc?
Any help appreciated..
Thanks,
Rashmi K.
|
|
|