I've been using FULL-TEXT for awhile but I cannot seem to get the most relevant results sometimes.

If I have an field with something like "An Overview of Pain Medicine 5/12/2006" and a user types "An Overview 5/12/2006"

So we create a search like: '"An" AND "Overview" AND "5/12/2006"' - 0 results (bad) '"Overview" AND "5/12/2006"' - 1 result (good)

The CONTAINSTABLE portion of my query:

FROM         ce_Activity A
INNER JOIN
    CONTAINSTABLE(View_Activities,(Searchable), @Search) AS KeyTbl ON A.ActivityID = KeyTbl.[KEY]

"Searchable" is a field contains the activity title, and start date(converted to string) in one field so it's all search friendly.

Why would this happen?