String Operators
- reference
|
Couchbase Server Enterprise Edition 7.6 reaches End of Life on March 31, 2027. Please upgrade to 8.0.x by following Upgrade, or contact Couchbase Support. |
SQL++ provides the concatenation string operator.
Concatenation
The concatenation operator joins two strings. The result of the concatenation operator is also a string.
Example
The following example shows concatenation of two strings.
WITH airline AS (
[
{ "name": "Delta Airlines", "code": "DL" },
{ "name": "United Airlines", "code": "UA" }
]
)
SELECT name || " (" || code || ")" AS full_airline_name
FROM airline
[
{
"full_airline_name": "Delta Airlines (DL)"
},
{
"full_airline_name": "United Airlines (UA)"
}
]
Related Links
Refer to Comparison Operators for string comparisons.