Re: [GENERAL] COALESCE() or NVL()

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(at)azstarnet(dot)com