Concatenates two string values.

Syntax

expression || expression

Arguments

  • expression: a character expression of one of these types, or an expression that resolves to one of these types:

    • CHAR

    • VARCHAR

    • LONG VARCHAR

Examples

SELECT firstName || ' ' || lastName AS fullName FROM MYSQL.inventory.cust;

VALUES 'John' || ' Smith');
-- Returns John Smith