>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?
Where you execute this statement?
if in QA go to line 8 and see what fields you have on that line.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.