You could do it in a procedure. For each row, if the interesting field is
NULL, then you change it for a 0 and return the values with a suspend.

HTH.

Xavier.

----- Original Message -----
From: "Sandor Szollosi" <ssani@...>
To: <ib-support@yahoogroups.com>
Sent: Thursday, March 20, 2003 2:53 PM
Subject: [ib-support] Select question


> Hi all,
>
> Is there any way to select a null value from a field as 0 ?
> I'd like to add two fields, but they can contain null values.
>
> TIA
> Sandor
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>