devxlogo

Using the STRING_SPLIT Function in SQL Server

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. 

devx-admin

Share the Post: