Skip to main content
Concatenates, i.e. combines, the text representations of all the input parameters without a separator, in the order they are provided.

​
Syntax

—OR—

​
Parameters

​
CONCAT function

The parameters to the CONCAT function can be of any data type, and will be converted to their text representation before concatenation. NULL parameters to the CONCAT function are treated as empty strings and ignored. If all parameters are NULL, the result will be an empty string.

​
|| operator

To enable string concatenation, one parameter to the || operator must be of type TEXT, while the other parameter may be of any non-array data type. If one parameter to the || operator is NULL, the result will also be the non-null parameter; if both parameters are NULL, the result will be NULL. The concatenation operator || can also be used for array concatenation.

​
Return Type

TEXT

​
Example

The following example concatenates nickname and email from the players table:

Rows: 5Execution time: 14.47ms