This code does not appear to care that we have rows with both words vs only one word... select * from COLLABORATOR x inner join containstable (Collaborator,*, ' ISABOUT ( "hiv" weight (.5) or "gender" weight (.5) ) ' ) as KEY_TBL on x.ColId = KEY_TBL.[KEY] order by rank desc How can I make query weigh rows with both words higher, then followed by frequency of occurrances of either word. Thanks in advance for any help or information.
We have the same problem here, but we've been unable to find a solution to this either... I came here actually to ask the same thing when I realized no one has answered this post yet. Anybody found anything?