Re: [GENERAL] Null Conversion

[Jason Turner]

> Can anyone tell me how I might convert a null attribute value into a zero
> attribute value such that it can be multiplied in a query. 
> 
> In Oracle I could do:
> 
> sal*12*NVL(COMM, 0) AS "Annual Income"

sal * 12 * CAST(COMM AS float8) AS "Annual Income"

Cheers

Jason
-- 
Indigo Industrial Controls Ltd.
64-21-343-545
[EMAIL PROTECTED]

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster