Show all Hide all


Splits the supplied string into several substrings at a specific character or sequence of characters. Each substring is returned on a separate row in the resultset.

If the supplied value is an empty string then a single row with the value null is returned.

If the supplied value is null then no rows are returned.

Type: Table-valued function
Area of use: General use


@Txt mandatory nvarchar(max)
The text to split.
@Delimiter mandatory nvarchar(4000)
The delimiter. If this is null the entire string is returned. If it is an empty string each character will be returned on a separate line.


Resultset: String fragments

Each fragment is returned on a separate row.
Repeat mode: repeated exactly once
Row count: zero or more rows


ID mandatory int
Row number
Txt mandatory string