Re: How do I make 2 + Null = 2 ?

In article <31224E4B.71A9_at_mmacmail.jccbi.gov>, Russell_Foster_at_mmacmail.jccbi.gov says...
>
>I am writing a select statement for Oracle7-NT that needs to return a
>derived column that is the result of an arithmetic operation between two
>other columns. Ex: select col1, col2+(.5*(col3)) as derivedcol from
>table1;

select (nvl(col_a,0) + nvl(col_b,0)) from table ... etc. etc.

-- 


>-->-->-->-->-->-->-->-->-->-->-->-->-->-->-->-->-->

|                                                  |
|    Chris Kirke - cakirke_at_metroux.metrobbs.com    |  
|                                                  |
|    the opinions expressed here ..... whatever    |
|                                                  |
<--<--<--<--<--<--<--<--<--<--<--<--<--<--<--<--<--<