How do I rename null values found in GROUP BY column?

[jt]

Here's a sample result from the following statement:

select dept, sum(cost)
from dept
group by dept;

dept sum(cost)
---- --------
null 1000
200 20
300 100

Is there a way I can rename the null value to some other value?

[nobody]

look at nvl function

"jt" <ju**********@yahoo.com> wrote in message
news:6f**************************@posting.google.c om...

Here's a sample result from the following statement:

select dept, sum(cost)
from dept
group by dept;

dept sum(cost)
---- --------
null 1000
200 20
300 100

Is there a way I can rename the null value to some other value?