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.