Back to Starrocks

concat

docs/en/sql-reference/sql-functions/string-functions/concat.md

4.1.0701 B
Original Source

concat

This function combines multiple strings. If any of the parameter value is NULL, it will return NULL.

Syntax

Haskell
VARCHAR concat(VARCHAR,...)

Examples

Plain
MySQL > select concat("a", "b");
+------------------+
| concat('a', 'b') |
+------------------+
| ab               |
+------------------+

MySQL > select concat("a", "b", "c");
+-----------------------+
| concat('a', 'b', 'c') |
+-----------------------+
| abc                   |
+-----------------------+

MySQL > select concat("a", null, "c");
+------------------------+
| concat('a', NULL, 'c') |
+------------------------+
| NULL                   |
+------------------------+

keyword

CONCAT