SplitCount

Returns the highest available Index that can be used using the Split function (Simple Version)

Free Function
SQL Server Compatibility: 2008, 2012, 2014, 2016, 2017

Syntax:

SELECT SQLHTTP.net.SplitCount ( @Text, @Delimiter )

Arguments:

Name	Type	Description
@Text	nvarchar(MAX)	String expression containing substrings and delimiters.
@Delimiter	nvarchar(4000)	String of characters used to identify substring limits.



Return Type:

int



Sample Usage:

Simple split by a space character:


DECLARE @Text nvarchar(MAX)
DECLARE @Delimiter nvarchar(4000)

SET @Text = 'The quick brown fox jumps over the lazy dog'
SET @Delimiter = ' ' --one space character

SELECT SQLHTTP.net.SplitCount(@Text, @Delimiter)

DECLARE @Text nvarchar(MAX)

DECLARE @Delimiter nvarchar(4000)

SET @Text = 'The quick brown fox jumps over the lazy dog'

SET @Delimiter = ' ' --one space character

SELECT SQLHTTP.net.SplitCount(@Text, @Delimiter)

-----

Simple split by a two-character delimiter:


DECLARE @Text nvarchar(MAX)
DECLARE @Delimiter nvarchar(4000)

SET @Text = 'The quick brown fox jumps over the lazy dog'
SET @Delimiter = 'e ' --two character delimiter

SELECT SQLHTTP.net.SplitCount(@Text, @Delimiter)