>This application is so new, that I don't have any users for it yet. Given that the users at my company wouldn't know a NULL value from a hole in the ground, much less why they would ever want to enter it into a field, this begins to make a case for not having these occur in the tables at all. Instead, reasonable default values for the corresponding data types such as zeroes and blank strings could be used for fields.
>
>I just happened to stumble onto this nasty behavior because of default NULL values in some tables I am working with, which were designed by contractors who are since long-gone, and I want to make it stop. :) Not that I have a conceptual problem with null values themselves.
>
>Short Version of that gobbledegook: 'Hmm. Those are causing a weird, nasty side-effect, and maybe I will just get rid of them' :)
>
In that case, you could just use NVL() in your Select statement to convert the nulls right off.