title: sql - CASE return "true" if you compare NULL to NULL?
body: <p><code>DECODE</code> will return "true" if you compare <code>NULL</code> to <code>NULL</code>. <code>CASE</code> will not.</p>
  
  <p>How do i make <code>CASE</code> to return true if I compare <code>NULL</code> to <code>NULL</code>?</p>
  
  <p>An example of my current query. One problem is that if <code>a.name</code> is <code>null</code> and <code>b.name</code> is <code>null</code>, then it will return false. I want it to behaves like <code>DECODE</code> function from oracle sql.</p>
  
  <pre><code>SELECT CASE a.name
      WHEN b.name THEN 1
      ELSE 0
  END,
  FROM Employee1 a, Employee2 b 
  WHERE a.salary = b.salary;
  </code></pre>