SQL Full Text Search - Show which result/row hit against query

I have a FTS query - allowing the user to enter multiple search criteria against a blob/varbinary(max) field- is there a way, in the result set - to show which search criteria resulted in each returned row?
tbaseflugAsked:
Who is Participating?
 
Mark WillsConnect With a Mentor Topic AdvisorCommented:
Not really...

If there is a list of criteria it is very hard to determine which one was used in FTS for the match.

You can get a rank, but still doesn not say which of the criteria was successful, just that any one of them was (and pretty sure that as soon as one is, the others dont count anymore). Nor can you see which terms were superfluous to the search criteria.

You can have a look at the type of search scenarios : http://msdn.microsoft.com/en-us/library/cc879300.aspx and how they might be  ranked : http://msdn.microsoft.com/en-us/library/ms142524.aspx

But, the only real answer to your question is "no".

0
 
aikimarkCommented:
Post-closure thought.  You might post-process the results applying the individual comparison expressions.  It would get very complicated very quickly with the complexity of boolean operators.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.