title: How to decode nvarchar to text (SQL Server 2008 R2)?
body: <p>I have a SQL Server 2008 R2 table with <code>nvarchar(4000)</code> field. </p>
  
  <p>Data that stores this table look like </p>
  
  <p><code>'696D616765206D61726B65643A5472'</code> </p>
  
  <p>or </p>
  
  <p><code>'303131' ("011")</code>. </p>
  
  <p>I see that each char is encoding to hex.</p>
  
  <p>How can I read those data from table? I don't want write decoding function, I mean that simpler way exists.   </p>
  
  <p>P.S. Sorry for my English.</p>