SUM and NULL values

Posted in 1997

Akis Xenophontos — 2 Jul 1997 15:45:58 GMT — source: Informix-list mailing list archive (1991-1998)

E-mail Address: akisx@logica.com Name: Akis Xenophontos Company: Logica UK Ltd Postal Address: London NW1 Tel No: 0044171 446 1324 Date: 16/06/97 I have the following problem: select sum(a) + sum(b) + sum(c) from table_a returns null if columns values b are all null for example. Is there a way, within one SQL statement, to treat the NULL as a 0 and return the aggregate sum of columns a,b and c?