It was about 4 years ago that I’ve wrote a custom function to split a delimited string in T-SQL. I’ve wrote that because there was no split function for SQL Server at that time. Fortunately SQL Server 2016 comes with new excitements, and built-in split function is one of them.
The new String_Split function is a table function which has two inputs:
String_Split(<main string as input>,<delimiter>)
Usage of it should be within From clause of your query because this is a table function. Here is an example:
select * from string_split('this,is,a,test',',')
and here is the result:
You might only face an issue when the delimiter contains special reserved characters of t-sql, such as single quote: ‘
In those cases you can use another signle quote to escape that especial character.