xxxxxxxxxx
select cast(XMLCol as nvarchar(max)) as XMLCol
xxxxxxxxxx
DECLARE @xmlData XML
SET @xmlData = '<root><element1>Value 1</element1><element2>Value 2</element2></root>'
DECLARE @xmlString VARCHAR(MAX)
SET @xmlString = CAST(@xmlData AS NVARCHAR(MAX))
SELECT @xmlString AS XmlString