idused
I ran the following:
-----
declare @temp xml
set @temp = '<root />'
declare @found bit
set @found = (
select @temp.exist('/root/text()="hi"'))
print @found
---
and the result is:
---
1
---
why 1
I am expecting 0!