Quick Ref.
Compatibility
CONCAT(s1, s2)
Engine OK Alternative
ingres yes
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: