CONCAT (Azure Cosmos DB)CONCAT (Azure Cosmos DB)

返回一个字符串,该字符串是连接两个或多个字符串值的结果。Returns a string that is the result of concatenating two or more string values.

语法Syntax

CONCAT(<str_expr1>, <str_expr2> [, <str_exprN>])  

参数Arguments

str_exprstr_expr
是要连接到其他值的字符串表达式。Is a string expression to concatenate to the other values. CONCAT 函数需要至少两个 str_expr 参数。The CONCAT function requires at least two str_expr arguments.

返回类型Return types

返回一个字符串表达式。Returns a string expression.

示例Examples

以下示例返回将指定值串联后形成的字符串。The following example returns the concatenated string of the specified values.

SELECT CONCAT("abc", "def") AS concat  

下面是结果集。Here is the result set.

[{"concat": "abcdef"}]  

备注Remarks

此系统函数不会使用索引。This system function will not utilize the index.

后续步骤Next steps