String_Split Function In SQL Server 2016

String_Split function takes two parameters. The first Parameter is a string, which will be split according the value of the second parameter. The second parameter of String_split function will define the value of the separator. String_Split function splits the string (defined in first parameter), according to the value of the separator (second parameter) and returns a table.
 
Syntax
 

Example 1
 
 
 
Example 2