Hi Mike

Here is another explanation of the problem.

We can create a table before populating it. We extract data from a number of other tables in the database. When we go to insert the data into the previously created target table we get the truncation errors. This must mean that the corruption is occurring at the time of the extraction, or at least while the data in memory.

Is there an easy way of determining whether I have corrupt data in these other tables? If not, what's the hard way?

Keith