On Wed, 15 Aug 2001, Mike Withers wrote:
> 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 c
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:
>>
>> sal*12*NVL(COMM, 0) AS "Annual Income"
>
> 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
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:
>
> sal*12*NVL(COMM, 0) AS "Annual Income"
>
> where COMM is an attribute (a salesman com
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
