title: SQL String are same but case equals method returns false
body: <p>I am using <code>SQL</code> to compare two columns and return <code>TRUE</code>/<code>FALSE</code> if they are equal.</p>
  
  <p>In some cases, the two columns contain exactly the same string (no spaces or anything) but I am still getting false. </p>
  
  <p>What may the reason for this be?</p>
  
  <p>I am using this code: </p>
  
  <pre><code>CASE WHEN column1 = column2 THEN 0 ELSE 1 END AS [check]
  </code></pre>