On Thu, 18 Apr 2002 08:14:01 -0000 "maria_ana_ph" <maria_ana_ph@...>
wrote:

> The problem is, if the second field (FIELD2) is NULL, the third field
> (CAST (A.FIELD2 AS FLOAT) - CAST (B.FIELD2 AS FLOAT)) would return
> NULL where it should the value of FIELD2.
>
> Do you know how would i go about this?

Is there a wish list for Firebird? The COALESCE function would be a good
addition....

Then you could say (CAST (COALESCE(A.FIELD2,0) AS FLOAT) - CAST (B.FIELD2
AS FLOAT))

Regards