devxlogo

May 22, 2018

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