Please use the form below to provide your feedback. Because your feedback is valuable to us, the information you submit in this form is recorded in our issue tracking system (JIRA), which is publicly available. You can track the status of your feedback using the ticket number displayed in the dialog once you submit the form.

String Operators

  • reference

SQL++ provides the concatenation string operator.

Concatenation

The concatenation operator joins two strings. The result of the concatenation operator is also a string.

Syntax

concatenation-term ::= expr '||' expr
Syntax diagram

Example

The following example shows concatenation of two strings.

Query
WITH airline AS (
   [
      { "name": "Delta Airlines", "code": "DL" },
      { "name": "United Airlines", "code": "UA" }
   ]
)
SELECT name || " (" || code || ")" AS full_airline_name
FROM airline
Result
[
  {
    "full_airline_name": "Delta Airlines (DL)"
  },
  {
    "full_airline_name": "United Airlines (UA)"
  }
]

Refer to Comparison Operators for string comparisons.