CONCAT

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Concatenates the text representations of all arguments, ignoring NULL values.

1concat(<value1> [, value2 [, ...]])

• <value1>: The first value to concatenate.

• value2, ...: Additional values to concatenate.

Returns a text value containing all non-NULL arguments concatenated together.

• Unlike the || operator, the function ignores NULL arguments.
• Converts all arguments to their text representation.

Combine values including NULL.

1SELECT concat('abcde', 2, NULL, 22) AS result;

Returns 'abcde222'. Ignores the NULL.

• String Types