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

Filed under:
|
|

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

Related posts about sql

Related posts about server