A database on the
MS SQL Server 2008 R2
SSRS web report
Yes, you can cast the
Xml and then use features such as XQuery to parse the Xml document. You will however first need to cast it through
VARBINARY as well.
SELECT CAST(cast(SomeXmlStoredAsBlob AS VARBINARY(MAX)) AS XML) AS MyXml FROM MyTable
I would recommend changing the column type ASAP - if all data is Xml, then convert it to Xml as per above, and if there are different formats, then use