MS SQL Statement to make amount field all Zero's when the field is null
I have this statement to pad amounts with zero's and change the dollar amount from negative to positive.
When a check is voided, it is a null amount for the dist_amt. How do we populate just zero's when the amount is null included in this statement? Also, if there is a better way to write this entire statement, please advise as well. Thanks in advance.