Skip to content
Home ยป sql server string split function

sql server string split function

SQL Server STRING_SPLIT Function

SQL Server STRING_SPLIT function is used to split a string into a table that consists of rows of substrings based on a specified separator. This function was introduced in SQL Server 2016 .

STRING_SPLIT requires the compatibility level to be at least 130. When the level is less than 130, SQL Server is unable to find the STRING_SPLIT function.

 6,049 total views,  9 views today