Using XML column in a where clause in SQL 2008

Question

I have a stored procedure in which I need to have a where clause that reads something like:

where XMLDataPoint <> NULL

However, XMLDataPoint is an XML column and I get an error

"The XML data type cannot be compared or sorted, except when using the IS NULL operator."

How should I structure my where clause?

JNK · Accepted Answer · 2012-01-13 19:41:24Z

3

NULL requires using IS or IS NOT comparisons:

WHERE XMLDataPoint IS NOT NULL

NULL is a state (of having an unknown or undetermined value), not a value itself, so equivalence operators don't apply.

answered Jan 13, 2012 at 19:41

JNK

65.5k15 gold badges127 silver badges138 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1