title: how to compare SQL dates with null
body: <p>I want to count the number of rows having date is null.i tried following</p>
  
  <pre><code>SELECT R.COUNTRY_CD,COUNT(R.EFFECTIVE_END_DT) AS d_null
  FROM REIMBURSEMENT R
  GROUP BY R.COUNTRY_CD,R.EFFECTIVE_END_DT
  HAVING R.COUNTRY_CD = @COUNTRY_CD AND R.EFFECTIVE_END_DT IS NULL
  </code></pre>
  
  <p>but it's giving d_null as 0...</p>
  
  <p>how can i compare a date for <code>NULL</code></p>