String concatenation is the process of combining 2 or more strings into 1 string. Standard SQL use two vertical bar ( ||) to denote concatenation. 

Table: Orders

OrderID	Customer	Employee	Order Date	ShippedVia	Freight	ShipCountry
10248	Wilman Kala	Buchanan, Steven	04-07-1996	Federal Shipping	$32.38	France
10249	Hanari Carnes	Peacock, Margaret	08-07-1996	United Package	$65.83	Brazil
10250	Hanari Carnes	Leverling, Janet	08-Jul-1996	United Package	$58.17	Brazil
10251	Chop-suey Chinese	Buchanan, Steven	11-Jul-1996	United Package	$22.98	Switzerland
10252	Richter Supermarket	Dodsworth, Anne	12-Jul-1996	Federal Express	$148.33	Switzerland

Let's take a look at the following SQL statement:

SELECT Customer || ' , ' || ShippedCountry AS Cust_Country FROM Orders;

The above SQL statement will return results as follow:

Cust_Country

Wilman Kala, France

Hanari Carnes, Brazil

Hanari Carnes, Brazil

Chop-suey Chinese, Switzerland

Richter Supermarket, Switzerland

.