Show allHide all
Type: Table-valued function

(SQL Server 2016 introduced the built-in function STRING_SPLIT. Its behavior is not identical to SoftadminUtil.String_Split so you can not simply replace calls to one with the other, but you should consider writing new code using the built-in function.)

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.


@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.
Table count: repeated exactly once
Row count: zero or more rows


ID mandatory int
Row number
Txt mandatory string