Using the STRING_SPLIT Function in SQL Server

SQL Server 2016 provides a way to split a string that is concatenated with a separator.

For example:

SELECT VALUE FROM STRING_SPLIT("John|Mary|Dohe", "|") would return the values John, Mary and Dohe in 3 rows. 
Share the Post:
Share on facebook
Share on twitter
Share on linkedin


Recent Articles: