title: Conversion failed when converting the varchar value to data type bit in sql server
body: <p>Here i try to convert a bit value to varchar , i try this query in MS sql server </p>
  
  <pre><code>CASE WHEN cast(ISNULL(O.isTerminated,0)as varchar) = 1 THEN 'Yes' ELSE '' END AS   isTerminated.
  </code></pre>
  
  <p>Is giving error "Conversion failed when converting the varchar value 'Yes' to data type bit."</p>
  
  <p>what will be the solution for this.</p>