fnMFSplitString¶

Signature¶

dbo.fnMFSplitString(
    @Input     NVARCHAR(MAX),
    @Character CHAR(1)
)

Table-valued result with one row per token: - Value NVARCHAR(…) - Position INT (1-based index)

@Input NVARCHAR(MAX) (required) - Values separated by a delimiter, e.g., ‘a,b,c’.
@Character CHAR(1) (required) - The single-character delimiter, e.g., ‘,’.

Split a delimited string into rows.

SELECT *
FROM dbo.fnMFSplitString('a,b,c', ',');