Skip to content
Home ยป Remove term: How to split a comma separated string into single column table SSQL How to split a comma separated string into single column table SQL

Remove term: How to split a comma separated string into single column table SSQL How to split a comma separated string into single column table SQL

SQL 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.

Loading