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:

In today’s digital world, technology has changed how we make payments. From contactless cards to mobile wallets, it’s now easier

January 26, 2023

No matter what you do or where you work, you are likely to encounter Windows software at some point or

January 25, 2023