Hi,

With Firebird, you can use the xNVL UDF functions to solve this problem.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com



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))