>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). I still use old UNION ... WHERE ... NOT IN syntax.