|| [concatenation]

All functions > STRING > || [concatenation]

Concatenates two strings; chains associate to the left (same underlying CONCAT_FN bundle as variadic CONCAT).

Syntax

left || right  ·  CONCAT(left, right, …)

left || right  ·  CONCAT(left, right, …)

Notes

• a || b || c groups as (a || b) || c
• Same NULL omission rules as CONCAT: use NULL(VARCHAR) where needed; omitted NULLs do not add separators (there are none)
• For more than two pieces without nesting, prefer variadic CONCAT(...) when it reads clearer

Related Functions

• CONCAT(...)

Examples

Operator ||

SELECT
    f1 := 'A' || 'B', -- Two operands
    f2 := 'A' || 'B' || 'C' -- Left-associative chain
;

Edge cases

SELECT
    f1 := 'Hello' || ' ' || 'World' -- Building a phrase
;