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.

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

Returns 'Hyper'.

Demonstrate NULL handling.

Returns NULL because one operand is NULL.

Concatenate a string with a number.

Returns 'Value: 42'.