Thank this author by sharing:
By kgayda, 2013/05/24
Since T-SQL has no array data type, passing delimited strings is a great way to send a variable number of parameters to a function or stored procedure. This function behaves similarly to the VBScript function or Javascript String.split method. You pass it a delimited string and the delimiter where the split should occur. Returns a table data type as a psuedo array. I have added to my model database so a copy is made for all new DBs
A useful SQL function to parse a single string with delimited values for the "N"th occurrence
Feed it large strings of delimited horizontal data and it returns it back as a vertical table.
Feed it delimited horizontal data and it returns it back as a vertical table.
"function"
Feed it large strings of double-delimited horizontal data and it returns it back as a non-pivoted ve...
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com
