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

CONCAT

CONCAT allows you to stick two or more strings together.

This operation is concatenation.

 CONCAT(s1, s2 ...) 

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


Results
See also: