Quick Ref.
Functions
date
number
string
Data Types
date
number
string
Compatibility
s1 + s2
Engine OK Alternative
mysql no CONCAT(s1, s2)
oracle no s1 || s2
postgres no s1 || s2
sqlserver yes

+ (string)

+ allows you to stick two or more strings together.

This operation is concatenation. 

 s1 + s2

In this example you put the region and the name together for each country.


Results
See also: