title: Convert Image DataType To String in SQL Server
body: <p>I have a Column having <code>Image</code> datatype in MS-SQL SERVER 2012. I want to get it as string in SQL Query..</p>
  
  <p>I have Tried This:</p>
  
  <pre><code>SELECT 
  'empphoto : '+ ISNULL(CONVERT(VARCHAR(MAX), CONVERT(VARBINARY(MAX), empphoto)),'') 
  from emppersonal where --some condition
  
  --empphoto Columns is of Image datatype
  </code></pre>
  
  <p>output looks corrupted (Just 4 characters).</p>
  
  <p>OutPut looks like:</p>
  
  <pre><code>empphoto : ÿØÿà
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/JuRpP.jpg" alt="enter image description here"></p>
  
  <p>How can be an <code>Image</code> datatype be converted to string in MS-SQL Server?</p>