check if a value is NULL or Less than 0 in one TSQL statement

Question

ISNULL(SUM(MyTable.Total), 0) AS Total

How can I modify the above statement to also check if Total is less than 0 (zero), such that If Total is NULL or less than 0 (negative), I assign 0 to Total

Answer 1

CASE WHEN ISNULL(SUM(MyTable.Total), 0) <= 0 THEN 0
     ELSE SUM(MyTable.Total)
END AS Total