title: Varbinary and image conversion
body: <p>I have an Access front end that links to a SQL Server backend.</p>
  
  <p>There are 3 fields in a table that I am trying to convert to text from the backend:</p>
  
  <pre><code>o_name                varbinary(2000)  
  O_PropertyBinary1     varbinary(2000)  
  O_PropertyBinary2     image
  </code></pre>
  
  <p>I can convert the <code>o_name</code> field using:</p>
  
  <pre><code>convert(varchar([max]),[O_Name])  
  </code></pre>
  
  <p>and that works fine.</p>
  
  <pre><code>e.g. 4153534554  = ASSET
  </code></pre>
  
  <p>However, what can I use for the other two fields, as it seems I can't convert an image field and converting the <code>O_PropertyBinary1</code> comes out with garbage characters.</p>