> why not use a NVL in your select staetment? That is what I'll probably end up doing unless I hear a good answer. The problem is that my selects are dynamic so I have no idea what types the columns are. So I'll probably end up querying the system table for column information, and then if that column is nullable, I'll do an isnull() (I'm on Sybase) with an appropriate value.
But I'd rather not have to go through all that mess and I think it might be a useful feature others would like too. Mitch
