hello!

i have an sql statement that looks like this:

SELECT FIELD1,
CAST (A.FIELD2 AS FLOAT),
CAST(B.FIELD2 AS FLOAT),
CAST (A.FIELD2 AS FLOAT) - CAST (B.FIELD2 AS FLOAT)
FROM TABLE A, TABLE B

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?

Many thanks!
Maan 8)