How to CONCAT any string after and before the column value in SQL

If you want to add any value in the column with the hold value of the column

  1. Use the below query to add value after the column value
UPDATE TableName
SET ColumnName = CONCAT(ColumnName, 'add after')
WHERE id = @id;

If you run the above query,
before run the query value of the column: my value
after run the query value of the column: my value add after

Use the below query to add value before the column value

UPDATE TableName
SET ColumnName = CONCAT('add before', ColumnName)
WHERE id = @id;

If you run the above query,

before run the query value of the column: my value

after run the query value of the column: add before my value