Hi,

I use the following function in a udf based on Greg Deatz's code:

"
function DefZero(var Input: Double): Double;
begin
Result := Input;
end;
"

Works like a charm.

Best Regards,

David Montgomery
montgomery@...

> -----Original Message-----
> From: Usharani [mailto:usha@...]
> Sent: Tuesday, January 22, 2002 11:24 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Hai
>
>
> Hai all
>
> is there any function to replace null value with 0 like what we have in
> oracle NVL function.
>
> Thankx
>
>
>
>
> 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/
>
>

_________________________________________________________
Do You Yahoo!?
Get your free @... address at http://mail.yahoo.com