SELECT CONCAT(Address, " ", PostalCode, " ", City) AS Address FROM Customers;
CONCAT(string1, string2, ...., string_n)