NULL
col A
col B
null
SUM(A+B)
A=5, B = null
5
isnull
coalesce
SUM(COALESCE(A, 0) + COALESCE(B,0))
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)