concatenate columns in sql server code example

Example: sql concat string with column value

SELECT CONCAT(name, "string_value") AS name
FROM 
  users;