title: convert BLOB to text in sql
body: <p>I have a field in my database table with data type as <code>BLOB</code>.How can I view the content as <code>text/string</code> using a <code>SELECT</code> query in <code>SQL</code>. the content's <code>MIMETYPE</code> is <code>'text/xml charset=UTF8'</code></p>
  
  <p>I tried with this, I'm not sure if im right with the syntax</p>
  
  <pre><code>SELECT 
  CAST((SELECT column FROM myTable WHERE ID='56')AS CHAR(10000) CHARACTER SET utf8)
  </code></pre>
  
  <p>and also</p>
  
  <pre><code>SELECT 
  CONVERT(VARCHAR(max), CAST((SELECT column FROM myTable WHERE ID='56') 
  as binary)) from BIZDOCCONTENT
  </code></pre>
  
  <p>many Thanks</p>