Events
Mar 17, 9 PM - Mar 21, 10 AM
Join the meetup series to build scalable AI solutions based on real-world use cases with fellow developers and experts.
Register nowThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
APPLIES TO:
NoSQL
Returns a string that is the result of concatenating two or more string values.
CONCAT(<string_expr_1>, <string_expr_2> [, <string_expr_N>])
Description | |
---|---|
string_expr_1 |
The first string expression in the list. |
string_expr_2 |
The second string expression in the list. |
string_expr_N (Optional) |
Optional string expression[s], which can contain a variable number of expressions up to the N th item in the list. |
Note
The CONCAT
function requires at least two string expression arguments.
Returns a string expression.
This first example returns the concatenated string of two string expressions.
SELECT VALUE
CONCAT("adventure", "works")
[
"adventureworks"
]
This next example uses an existing item in a container with various relevant fields.
[
{
"slug": "duonovi-pro-coat",
"model": "8061",
"category": "heavy-coats"
}
]
This example uses the function to select two expressions from the item.
SELECT VALUE {
sku: CONCAT(p.slug, "-", p.category, "-", p.model)
}
FROM
products p
WHERE
p.category = "heavy-coats"
[
{
"sku": "duonovi-pro-coat-heavy-coats-8061"
}
]
Events
Mar 17, 9 PM - Mar 21, 10 AM
Join the meetup series to build scalable AI solutions based on real-world use cases with fellow developers and experts.
Register now