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@azstarnet.com