CONCAT

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

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

• <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.

Returns 'abcde222'. Ignores the NULL.

• String Types