Using CONCATENATE Function
Syntax:
SELECT “column_name1” + ‘ ‘ + “column_name2” store_name FROM “table_name”
Example:
SELECT Store_name + ‘ ‘ + Location store_name FROM Store_Sales
In the above example it displays all Stores and locations separated with a space in between.