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.