>I'm trying to append data to a table (that does not accept nulls) from the results of a left outer join that has many nulls. Is there a way to get rid of null in the select using the outer join. I tried iif(isnull(x.value),"",x.value) but no luck.
>
>Regards

Miles,
Use the NVL(expr1, expr2) function. If the first expression is not NULL, it will be returned. If it is, the second expression will be returned.

HTH.