ADMIN_SplitString

 Show all Hide all

Deprecated.

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

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

Columns:

ID mandatory int
Row number
Txt mandatory string
Fragment