title: How do I wrap a value in a CDATA tag when creating XML in SQL Server?
body: <p>How do I wrap OldValue in a CDATA?</p>
  
  <pre><code>SELECT
  1 AS Tag,
  0 AS Parent,
  (
      SELECT PositionDescription AS 'data()'
       FROM dbo.Project where ID = 32
       FOR XML PATH('')
  ) AS 'PositionDescription!1!OldValue!CDATA'
  FOR XML EXPLICIT, TYPE 
  </code></pre>