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.
Visit the DevX Tip Bank