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