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