update and keep original value sql
snippet in sql

update and keep original value sql

user2140

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