I have the requirement to find the sum of a number of fields in one data row.
In short I have the following:
SELECT Seq01 + Seq02+Seq03+Seq04 as ItemSum FROM Tablename
The issue I have is if one of the fields is null the query fails. How can I get around this?
Any help would be great.