>DECLARE @xml nvarchar(4000) >DECLARE @h int >SET @xml = ' ><root> > <row id="1"><![CDATA[ THIS IS >SO ME >DATA ]]></row> ></root>' > >EXECUTE sp_xml_preparedocument @h output, @xml > >SELECT * FROM OPENXML(@h, '//row') WITH (id int '@id', note nvarchar(2000) 'text()') > >execute sp_xml_removedocument @hYou can use < pre > tag to preserve formatting and XML/HTML tags.