update and keep original value sql code example

Example: update and keep original value sql

UPDATE Person 
SET Person_name = Person_name + ' ' + 'Mary' 
WHERE Person_id = 1;