Skip to main content

CONCAT

Returns the string that results from concatenating the arguments. May have one or more arguments. If all arguments are nonbinary strings, the result is a nonbinary string. If the arguments include any binary strings, the result is a binary string. A numeric argument is converted to its equivalent nonbinary string form.

Syntax​

CONCAT(column1, ...)

Arguments​

ArgumentsDescription
columnstring column

Return Type​

A String data type value Or Null data type.

Examples​

SELECT CONCAT('data', 'bend');
+------------------------+
| concat('data', 'bend') |
+------------------------+
| databend |
+------------------------+

SELECT CONCAT('data', NULL, 'bend');
+------------------------------+
| CONCAT('data', NULL, 'bend') |
+------------------------------+
| NULL |
+------------------------------+

SELECT CONCAT(14.3);
+--------------+
| concat(14.3) |
+--------------+
| 14.3 |
+--------------+

SELECT CONCAT(number, 'a', number+1) FROM NUMBERS(3) ORDER BY number;
+-----------------------------------+
| CONCAT(number, 'a', (number + 1)) |
+-----------------------------------+
| 0a1 |
| 1a2 |
| 2a3 |
+-----------------------------------+

SELECT CONCAT(number, NULL) from numbers(4);
+----------------------+
| CONCAT(number, NULL) |
+----------------------+
| NULL |
| NULL |
| NULL |
| NULL |
+----------------------+