I'm trying to put together a summary page for a db a customer has, and I'm trying to simply use SUM() to add up the fields as follows:SELECT SUM(CONVERT(numeric, ISNULL(Planned, 0))) AS Planned ...

Null means "undefined" in SQL, so numerous online services don't think Christopher Null exists. ... "Allowing NULL values makes you work extra hard to get the kind of data you are looking for.