How to query against exact values in XML column set
Specifying the text() node before the predicate will be more efficient than having text() in the predicate.

select *
from #ColumnSet as C
where AllValues.exist('*/text()[. = "POSITIVE"]') = 1






Query plan with text in the predicate AllValues.exist('*[text() = "POSITIVE"]') = 1