error 8152

[hmcheung]

I want to do this:

update table_1
set col_1='ABC' + rtrim(col_2)


but I get this:

msg 8152
String or binary data would be truncated.
the statement has been terminated.


How can I get around this error?
Thanks! Please visit my WebCam!!

http://i.am/andycheung

http://home.netvigator.com/~familysc

 

[ColinM]

if you do:

select max(len('ABC'+rtrim(col2)))
then you will probably find that this is still greater than the length you have allowed for in col1, so simply increase col1.