| Subject | How to change SUM() result NULL to 0 |
|---|---|
| Author | jasajona |
| Post date | 2004-11-26T17:44:48Z |
Hello,
How to change SUM() result NULL to 0
-----------------
select
sum(field1)
from
table1
group by
field2
-----------------
So if sum(field1) returns NULL I want to see it as 0.
I tryed many things but no one work (all I get is NULL). Is it FB bug?
I am
using 1.5.1 .
How to change SUM() result NULL to 0
-----------------
select
sum(field1)
from
table1
group by
field2
-----------------
So if sum(field1) returns NULL I want to see it as 0.
I tryed many things but no one work (all I get is NULL). Is it FB bug?
I am
using 1.5.1 .