Re: null = 0 ?

Article View: borland.public.vdbase.data.sql

Article #1029

Back to borland.public.vdbase.data.sql Previous Next

#1029

From: Paul Franks
Date: Wed, 03 Jun 1998 00:00

12 lines
933 bytes

Did you consider using a 'FOR NOT NULL' construct to ignore null values?

In article <6kviil$kfs7@forums.borland.com>, sdegenaar@yahoo.com says...
> Yes is it is vital that I do get the 0's as well as it is part of one of the
> fields in the report (or sql) that is needed to do a sum of the whole row.
> You cannot do a agg function including a null field. Therefore it is vital
> that somehow I can get the null = to 0.00
> 

-- 
Paul Franks (TeamB)

Technical Details

Message-ID: <MPG.fdeb72acbf0e9249896da@forums.inprise.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <6ktg5s$jaf1@forums.borland.com> <6kv2v9$kfr3@forums.borland.com> <6kviil$kfs7@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,e593e030585ee67d
X-Google-Attributes: gidff5a1,public
From: supportingo@borland.com (Paul Franks)
Subject: Re: null = 0 ?
Date: 1998/06/03
Message-ID: <MPG.fdeb72acbf0e9249896da@forums.inprise.com>
X-Deja-AN: 358989332
References: <6ktg5s$jaf1@forums.borland.com> <6kv2v9$kfr3@forums.borland.com> <6kviil$kfs7@forums.borland.com>
Organization: TeamB
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message