At 12:03 PM 6/17/98 +0000, Jose' Soares Da Silva wrote:
>> Jose' Soares Da Silva writes:
>> > SELECT name,NVL(salary)+100 AS dream FROM emp;
>> > name |dream
>> > -----------+-----
>> > Sam | 1300
>> > Claire | 5100
>> > Bill | 4300
>> > Ginger | 4900
>> > NULL VALUES| <--- I expected 100 here.
>> > (5 rows)
SELECT name, NVL(salary, 0) + 100 AS dream FROM emp;
NVL() takes two values: the column/variable, and the value to use if NULL.
--
Robin Thomas
rthomas@azstarnet.com