Re: null = 0 ?

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

Article #1021

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

#1021

From: Bowen Moursund
Date: Mon, 01 Jun 1998 00:00

18 lines
1287 bytes

>How do you make a null field generated by an sql statement = to 0 so that
>you can perform arithimitic operations on it. I need to do this for a
>report. Is it easier (or better) to do change the value of the null somehow
>within the sql statement and then do arithimitic, or to change the value of
>the null to 0 within the report and then do the arithitic?

It depends upon whether you need 0's, or simply need to exclude the rows
with nulls.
If the latter (the simplest), you might set query.sql to something like:

 select * from THETABLE where THEFIELD is not null
____
Bowen Moursund (TeamB)
bowenNOSPAM@nerds.com
http://lonestar.texas.net/~moursund/
Try this help resource:
 http://www.dejanews.com/home_ps.shtml

Technical Details

Message-ID: <6kv2v9$kfr3@forums.borland.com>

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

References: <6ktg5s$jaf1@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: "Bowen Moursund" <<teamb@opto-pps.com>
Subject: Re: null = 0 ?
Date: 1998/06/01
Message-ID: <6kv2v9$kfr3@forums.borland.com>
X-Deja-AN: 358566166
Content-Transfer-Encoding: 7bit
References: <6ktg5s$jaf1@forums.borland.com>
Content-Type: text/plain; charset="iso-8859-1"
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Organization: DataTech
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message