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"
where COMM is an attribute (a salesman commission, in an employes table)
which has null values. This allows null commissions for non salesmen to
give a zero calculated value. The NVL converts a null into zero.
Thanks in anticipation
Mike Withers
University of Western Sydney
Australia
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
