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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
aikimark
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.