Re: NVL Blues
From: Mike Ressler <mjress_at_ingr.com>
Date: 1995/06/20
Message-ID: <3s6one$boe_at_b10.b10.ingr.com>#1/1
Date: 1995/06/20
Message-ID: <3s6one$boe_at_b10.b10.ingr.com>#1/1
You can try
set null 0;
This will convert your nulls to whatever, in this case 0. I don't know for sure if it works for calculations or not. It does for your output though.
Mike Ressler Received on Tue Jun 20 1995 - 00:00:00 CEST