Could try something like: SELECT x,y,z, COALESCE(x,0) + COALESCE(y,0) + COALESCE(z,0) as [Row Total] FROM .............