title: SQL Server convert varbinary to string
body: <p>I have a table that has a varbinary field like:</p>
  
  <p>0x83838383838372723 .....</p>
  
  <p>I would like to concatenate this varbinary field to a string, for example:</p>
  
  <pre><code>SELECT CONCAT('Varbinary value is', varbinary_field)
  FROM MyTable
  </code></pre>
  
  <p>I expect the following string:</p>
  
  <pre><code>Varbinary value is 0x83838383838372723
  </code></pre>
  
  <p>I need to use concat so how to do it?</p>