String Operators

String Operators

N1QL provides the concatenation string operator. The result of the concatenation operator is also a string.

expression || expression  

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"
    }
  ]
}