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

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

sql-server-2005 t-sql

Edit Report

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

0 Answers

Your Answer