Concatenate

Question

How do I separate two names by space

Answer 1

Use concat function

SELECT concat(firstname,' ', lastname) as name, City
FROM Customers

Answer 2

Thanks AJ