W3School TIY Editor

SELECT CustomerName, CONCAT(Address, " ", PostalCode, " ", City) AS Address FROM Customers;