Hi, Say I have an external table with 4 columns like this. (Actual tables have more than 100 columns). C1 C2 C3 C4 And the actual table is exactly the same. The easiest thing to do is to do a INSERT...SELECT. However, say that I need to call a function on the first column to retrieve / convert a lookup value. How can I now do a INSERT /