CONCAT SQL

Postgre:
SELECT 'The Name: ' || name AS name_info FROM employee;
SELECT field1 || name AS name_info FROM employee;

Mysql:
Select Concat('string', fieldname1) as newfield from tablename
Select Concat(fieldname0, fieldname1) as newfield from tablename

SQL Server:
SELECT region_name + ' ' + store_name FROM Geography
WHERE store_name = 'Boston';