This blog show how to update the column or we can say to concantinate some data to the exisitng column using the Update statement. Update statement has a property .Write which provides this feature to do a concantination to the existing available data in a column.
Syntax:
Update Table
Set Column = .write(Value, @offset, @length)
Where Condition
Example:
Update Emptable
Set empresume = ' Put the whole content here of the resume '
Where empid = 1
Update table
Set empresume = .Write('Adding some extra comments here', null, null)
Where empid = 1
So in the result set we will have the combined value in the empresume column as "Put the whole content here of the resume Adding some extra comments here"