Show all Hide all

Concatenates all strings in @Value using @Separator as separator. The strings are concatenated according to @SortOrder in ascending order.

Type: Aggregate function
Area of use: General use

Return value: nvarchar(max)

The concatenated string or NULL if there are no strings to concatenate (i.e the query returned zero rows).


@value mandatory nvarchar(max)
Must not be NULL
@separator mandatory nvarchar(4000)
Must not be NULL
@sortOrder mandatory int
Must not be NULL