Duplicate xml column insert

I have a table that stores an XML data type. I'm trying to compare what is in the table against data that will be inserted.

How do I Query and compare开发者_运维百科 a sql XML data type to a table XML column?

I converted the data column to a varchar and did a string compare.

In Oracle you could compare CLOB's by using dbms_lob.compare

I converted the data column to a varchar and did a string compare.