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.

A newer version of this documentation is available.

View Latest

String Operators

  • reference
    +

    N1QL provides the concatenation string operator.

    Concatenation

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

    Syntax

    expression || expression
    Syntax diagram

    Example

    The following example shows concatenation of two strings.

    Query
    SELECT fname || " " || lname AS full_name
    FROM tutorial
    Result
     {
  "results": [
    {
      "full_name": "Dave Smith"
    },
    {
      "full_name": "Earl Johnson"
    },
    {
      "full_name": "Fred Jackson"
    },
    {
      "full_name": "Harry Jackson"
    },
    {
      "full_name": "Ian Taylor"
    },
    {
      "full_name": "Jane Edwards"
    }
  ]
}

    Refer to Comparison Operators for string comparisons.