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

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? Received on Mon Aug 25 2003 - 17:51:34 CEST