|
I have a full-text index created upon a column of type varchar(max) with filestream enabled. The filestream contains data such as JPG's, TIF's, PDF's, and XML's (although this is mostly irrelevant to the question, I believe). I have two queries that I've created that allow me to search upon the index. Full-text search #1-- Full-text search #2-- The only significant difference between the two full-text searches is query #1 uses contains and query #2 uses containstable. My problem is that the two queries do not always yield the same results. For example, were I to search on the phrase "Independent contractors", query #1 would yield a result set of 10 different documents (PDF's and XML's), while query #2 would only yield a result set of 6. This seems to be the rule: query #1 always yields a few more than query #2, and query #2 always yields the exact same matches that query #1 does. Query #1 - search on "Independent contractors" yields: Query #2 - search on "Independent contractors" yields: Thanks for any help that I receive on this!!
(comments are locked)
|
|
Jagd - from reading the information in BOL I understand the main difference between I would imagine that is what you are seeing, as I think the explanation in BOL above is quite clear. HTH
(comments are locked)
|

