Purpose
This function returns the concatenation of a number of strings.
Syntax
concat::=
Usage notes
- The
CONCATfunction is equivalent to the concatenation operator ||. For more details, see Concatenation Operator (||).
The SQL literal NULL is handled as an empty string.
Example
Copy
SELECT CONCAT('abc','def') CONCAT;