>What if Table2.Column2 is a memo field? Does anything change, 254 characters are not going to be enough for the end result?
Kyle,
If you want to keep this field as a Memo, use CAST() function, e.g.
SET Column2 = CAST(alltrim(Column2) + " " + Column1 AS M)
If it's not broken, fix it until it is.
My Blog 
