Hi Borislav,

I wish it were so easy, but line 8 did not have anything to do with the problem (I was running it in SSMS in a query). Anyhow, it's all solved now.

>>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.