Using CONCATENATE Function

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.