>>To expand on Edward's response, you might want to check out the NVL() function to do that replacement of nulls during the SELECT itself.
>
>Yes, it's one of two ways, IMO -not the best one, because it will slow down the query (functions in field list).

Hmmm...I thought that was only a problem with functions in a WHERE or ON clause.