Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The STRINGJOIN function returns a string, which concatenates the elements of a specified array, using the specified separator between each element.
The STRINGJOIN function returns a string by concatenating the elements of an array using a specified separator in Azure Cosmos DB for NoSQL.
Syntax
STRINGJOIN(<array_expr>, <string_expr>)
Arguments
| Description | |
|---|---|
array_expr |
An array expression with all string items inside. |
string_expr |
A string expression to use as the separator. |
Return types
Returns a string expression.
Examples
This section contains examples of how to use this query language construct.
Join array elements into a string
In this example, the STRINGJOIN function is used to combine multiple strings from an array using various separators.
SELECT VALUE {
joinUsingSpaces: STRINGJOIN(["Iropa", "Mountain", "Bike"], " "),
joinUsingEmptyString: STRINGJOIN(["Iropa", "Mountain", "Bike"], ""),
joinUsingUndefined: STRINGJOIN(["Iropa", "Mountain", "Bike"], undefined),
joinUsingCharacter: STRINGJOIN(["6", "7", "4", "3"], "A"),
joinUsingPhrase: STRINGJOIN(["Adventure", "LT"], "Works")
}
[
{
"joinUsingSpaces": "Iropa Mountain Bike",
"joinUsingEmptyString": "IropaMountainBike",
"joinUsingCharacter": "6A7A4A3",
"joinUsingPhrase": "AdventureWorksLT"
}
]
Remarks
- This function doesn't utilize the index.