3 years later and STRING_SPLIT is still incomplete

Bit of a mini rant today I’m afraid. Many of us are aware that STRING_SPLIT was added in SQL Server 2016, and yet 3 years later it’s still incomplete. Why it’s incomplete There’s two major problems, in my view, with STRING_SPLIT. The first is that it doesn’t provide an ordinal position for the text extracted. For a string like ‘B,D,C,A’ this means you could just as easily get the rows A, B, C and D as you could B, D, C and A. When working with delimited data, knowing the ordinal position is often really important, and often a must….

Continue reading