ull 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
At 06:30 PM 8/14/01 -0700, you wrote:
>On Wed, 15 Aug 2001, Mike Withers wrote:
>
>> 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:
>>
>
ord
is selected as well.
Mike Withers
University of Western Sydney
Australia
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
