title: SQL Server converting image info to text
body: <p>I have been trying to convert a column in SQL Server to a <code>varchar</code> / <code>text</code> format. I am trying as below and didn't see expected output. Can anyone please help?</p>
  
  <pre><code>select top 10 
      convert(varchar(max), convert(varbinary(max), JobSpec)) 
  from ScheduledJob
  </code></pre>
  
  <p>The column contains data like this: (truncated the two rows as it contains huge lines)</p>
  
  <blockquote>
    <p>0xF9FFFFFF00000000000000000000000000000000260000007B38463642443236342D383838442D313144302D423137462D3230344334463446
    0xF9FFFFFF00000000000000000000000000000000260000007B38463642443236342D383838442D313144302D423137462D3230344334463446353032307D0000000000000000000000000000000000000000240000004A6F6220547970653A204164642D496</p>
  </blockquote>
  
  <p>The output from my query:</p>
  
  <pre><code>¨   
  ¨   
  ¨   
  ¨     
  ¨   
  ¨   
  ¨   
  ¨     
  ¨     
  ¨  
  </code></pre>
  
  <p>Please check and let me know the correct way to convert this into text.</p>