you can use this samlpe

UPDATE Yourtable SET Bemerkung = convert(varchar (2000),Bemerkun g) + 'Yourtext hire ' WHERE ID= 111111