Thanks, Garrett. I kinda thought this might be "the" way but was hoping for something that I didn't have to place on *every* field. Much appreciated!{s}

>>I'm doing a left outer join on two tables. I'd like the NULL's for the
>>unmatched values (for the right-side table) to show up as blank's and 0's
>>rather than NULL's.
>
>Check out the NVL() function: it returns either the current value, or the one you specify, if the value is null.