title: Convert SQL data in HTML format to standard text in SSRS
body: <p>I have an MVC2 C#. Net web app that is storing data in html format for certain description fields.  When displaying the data using SSRS, the data is showing with the excaped html characters...ie., </p>
  
  <pre><code>&amp;lt;p&amp;gt;&amp;amp;quot;YOU KNOW WHAT IT MEANS TO ASSUME&amp;amp;quot;&amp;lt;/p&amp;gt;  
  </code></pre>
  
  <p>So it looks weird in the report.  I can do Nested REPLACEs on the text to create the correct output:</p>
  
  <pre><code>"YOU KNOW WHAT IT MEANS TO ASSUME"
  </code></pre>
  
  <p>But it seems like there should be some kind of built in functinin SQL that would do this.</p>
  
  <p>Any ideas?</p>