MS SQL Server - stored procedure help

[ultim]

I have a basic select statement i.e.

SELECT
ID, A, B, C
FROM
tblScores

I would like to also return the sum of A,B,C AS 'Total'

However A,B or C can be nulls

I assume i would have to check for nulls and then them together? How do i achieve this?

 

[ultim]

Thanks! Appreciate the help.

Had to take out the Sum keyword to get it to work.

SELECT
ID, (ISNULL(A, 0)) + (ISNULL(B, 0)) + (ISNULL(C, 0)) AS [Total]
FROM
tblScores