I couldn't work out a way to tell which field was causing the problem so I just used the CAST() function to ensure all string fields were the right length and that solved the problem.
>Hi,
>
>I've got an error when trying to insert some data selected from one table into another:
>
>Msg 8152, Level 16, State 14, Line 8
>String or binary data would be truncated.
>
>Is there any way for me to tell which field it is referring to?