Subject RE: [ib-support] returning NULL values
Author Martijn Tonies

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

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

On Thu, 18 Apr 2002 08:14:01 -0000 "maria_ana_ph"

> 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

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