Concatenation Operator

The concatenation operator (||) concatenates character strings. For example,

SELECT last_name || ', ' || first_name AS full_name
FROM employee

If one of the operand is null, the result is null. In the example above, if in one of the rows “last_name” or “first_name” is null, the value of “full_name” is null.