ADMIN_SplitString

Show allHide all

Deprecated. Don't use for new development and try to migrate existing uses.

Type: Table-valued 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.

Parameters

@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.

Resultsets

Resultset: String fragments

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

Columns

ID mandatory int
Row number
Txt mandatory string
Fragment