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.