title: check if a value is NULL or Less than 0 in one TSQL statement
body: <pre><code>ISNULL(SUM(MyTable.Total), 0) AS Total
  </code></pre>
  
  <p>How can I modify the above statement to also check if Total is less than 0 <strong>(zero)</strong>, such that If Total is NULL or less than 0 <strong>(negative)</strong>, I assign 0 to <strong>Total</strong> </p>