Paul White
Is there a non-CLR string splitter for SQL Server 2016 that performs well for very large input strings and returns a reliable ordinal column like `STRING_SPLIT` can on SQL Server 2022 and Azure?
Top Answer
Paul White
This inline TVF converts the input string to JSON array format, then uses default `OPENJSON`.



Enter question or answer id or url (and optionally further answer ids/urls from the same question) from

Separate each id/url with a space. No need to list your own answers; they will be imported automatically.