Problem with Full text Searching
Posted
by devendra
on Stack Overflow
See other posts from Stack Overflow
or by devendra
Published on 2010-03-17T19:00:53Z
Indexed on
2010/03/17
19:21 UTC
Read the original article
Hit count: 311
I am searching in resumes weather the word is exist or not
i am using the below query
Case1:
select top(10) c_resume_text from sntbl_candidates
where contains(c_resume_text,'"a/dm"')
in the above example only it is not working properly .It showing resumes even though there is no text like that.
In Messages i am getting the following message.
Informational: The full-text search condition contained noise word(s).
if i try with
Case 2:
select top(10) c_resume_text from sntbl_candidates
where contains(c_resume_text,'"a/d')
i am getting proper results in case 2
can any one suggest me what to do.
Thanks
© Stack Overflow or respective owner