Full Text Search Issue

Question

I'm looking in a weather summary that a word exists or not

I am using the following query

Option 1:

select top(10) c_resume_text from sntbl_candidates
where contains(c_resume_text,'"a/dm"')

in the above example, only it does not work properly. It shows a summary, even if the text is missing.

In messages I get the following message.

Informational: the full-text search condition contains the word noise.

if i try with

Case 2:

select top(10) c_resume_text from sntbl_candidates
where contains(c_resume_text,'"a/d')

I get the correct results in case 2

can someone suggest me what to do.

thank

Answer 1

The answer to this question may give you what you need to know. Removing noise words in SQL Server 2005 full-text indexing