I have been using FULL-TEXT for a while, but sometimes I cannot get the most relevant results.
If I have a field with something like An Overview of Pain Medicine 5/12/2006 , and the custom type An Overview 5/12/2006
So, we create a search, for example:
"An" AND "Overview" AND "5/12/2006" - 0 results (bad)
"Overview" AND "5/12/2006" - 1 result (good)
The CONTAINING part of my request:
FROM ce_Activity A INNER JOIN CONTAINSTABLE(View_Activities,(Searchable), @Search) AS KeyTbl ON A.ActivityID = KeyTbl.[KEY]
"Searchable" is a field containing the activity header and start date (converted to string) in one field, so they are all search-friendly.
Why is this going to happen?
[UPDATE]
Ok, I just tested the NOISE word theory. I used "Pain" AND "Overview" AND "5/12/2006" and it works great.
But if I add an "from", it fails. "Of" and "An" should be noise words.
Now the question arises: how can I do this only IGNORE for words, and not remove it from the result if there is a noise word?
Any tips?