update query

Question

i have written a query in sp for update, but am getting result as the new value is appended to the old value insted of the new vale, why it happens?