description Transact-SQL reference for the STRING_SPLIT function. This table-valued function splits a string into substrings based on a character delimiter.

@value = RTRIM(LTRIM(SUBSTRING(@listOfValues,1,CHARINDEX(@delimiter, @listOfValues,0)-1))), @listOfValues = RTRIM(LTRIM(SUBSTRING(@listOfValues, CHARINDEX(@delimiter ...

The REGEXP_SPLIT_TO_TABLE table-valued regular expression function returns a table of strings split, delimited by the regex pattern. If there's no match to the pattern, the function returns the string ...