If for report, you can use SET NULLDISPLAY command.
>Yeah, it's been a brain dead day. Don't know what I was thinking. (Actually not thinking). Actually, I was wondering about generic code that would actually join three tables and avoid nulls using nvl() on all the fields, etc.
>
If it's not broken, fix it until it is.
My Blog 
