> The query SELECT SUM(NUMERIC_FIELD_X) FROM TABLE_X WHERE ... returns
> NULL if no records are found.

Unfortunately, this is how SQL committee designed it, so I doubt it will change in future releases.

Ivan
http://www.volny.cz/iprenosil/interbase