SQL: sum 3 columns when one column has a null value?

Question

SELECT      sum(TotalHoursM)           + (TotalHoursT)           + (TotalHoursW)           + (TotalHoursTH)           + (TotalHoursF)            AS TOTAL FROM LeaveRequest 

Answer 1

If the column has a 0 value, you are fine, my guess is that you have a problem with a Null value, in that case you would need to use IsNull(Column, 0) to ensure it is always 0 at minimum.