title: SQL-Query return zero count if no records are found
body: <p>I'm displaying records of a table which I <code>COUNT</code> a particular field. </p>
  
  <p>There might be sometimes the table might be empty and instead of displaying a <code>NULL</code> value i want it to come zero.</p>
  
  <pre><code>SELECT count(comment) as total
  FROM dbo.omment
  WHERE resp = MMColParam2 
    AND com_stat = 'No' having count(comment)&gt; 0
  </code></pre>