Skip to main content

Concatenation Operator

Returns the resultant string from the concatenation, or joining, of two or more string values.

See also:
[SELECT]

Syntax​

SELECT character_expression1 || character_expression2 FROM <multipartIdentifier>;

Arguments​

character_expression
A literal string or string column.

Return Value(s)​

Returns a string.

Examples​

Concatenate two fields together​

SELECT name || ' (' || location || ')' as bucket_location
FROM google.storage.buckets 
WHERE project = 'stackql-demo';

For more information, see https://sqlite.org/lang_expr.html