String Concatenation Operator (||)

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Concatenates two strings or a string and a non-string value, returning NULL if either operand is NULL.

1<string> || <right_value>

• <left_string>: The first string to concatenate.
• <right_value>: The second value to concatenate.

Returns a text value that contains the concatenated strings, or NULL if either operand is NULL.

• NULL arguments are NOT ignored. If either operand is NULL, the result is NULL.
• This differs from the concat function, which ignores NULL arguments.

Concatenate two string literals.

1SELECT 'Hy' || 'per' AS result;

Returns 'Hyper'.

Demonstrate NULL handling.

1SELECT 'Hy' || NULL AS result;

Returns NULL because one operand is NULL.

Concatenate a string with a number.

1SELECT 'Value: ' || 42 AS result;

Returns 'Value: 42'.

• String Types