Need help on a simple Update

[victora]

gentlemen/ladies,
Running on MSSQL Server 2000.
If somebody can tell me what is wrong with this code.

Thanks very much.



Code:
____________________________________
UPDATE MM_Refer
SET Ref_Stat_Cd = 'D',
Upd_User_Name = 'JOHN D NIED',
Upd_Date_Time = GETDATE()
FROM MM_Refer R
INNER JOIN XL_RefIds X
ON R.Ref_Id = X.Ref_Id

WHERE Ref_Stat_Cd = 'AP'
______________________________________
Error Message:
Server: Msg 8152, Level 16, State 4, Line 1
String or binary data would be truncated.
The statement has been terminated.

 

[victora]

Never mind! Found out my Upd_User_Name length is only 10.

Thanks