×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Using the STRING_SPLIT Function in SQL Server
 

Submitted by: Srinath M S(srinath_ms@yahoo.com)

Tuesday May 22nd 2018 by Srinath M S

Language: SQL, Expertise: Intermediate - Explore a way to split a string that is concatenated with a separator.

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. 
Home
Mobile Site | Full Site
Copyright 2018 © QuinStreet Inc. All Rights Reserved