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

|| (strings)

|| 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.

In MySQL the || is used for logical OR.


Results
See also: