>I'm actual selecting into a table. But I get the idea. Just go and replace all nulls in temp table before appending into the target table.
>
>Thank You

Miles,
This would require two passes through the data. One to get the intermediate table data and another to set replace the NULL values. NVL() would handle it in one pass. Both Oracle and SQL Server have this function to handle the same problem.