Revise t-sql function to parse string data

Kmlakov's script, t-sql function to parse string data, posted on 1/19/2005, required the passing in text ends with the delimiter. But it is usually not the case. I rewrote the script (added one IF statement). The new script can treat the text with or without ending delimiter. The third parameter will be the number of […]

5 (1)

2005-02-07 (first published: )

362 reads

Blogs

Fun and profit with UTF-8

By

When SQL Server 2019 was announced, it brought with it UTF-8 support. Also available...

Data Platform MVP 2020

By

I am humbled to be among so many great professionals and honored at the...

Daily Coping 12 Aug 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Removing TDE from a Database: Level 4 Stairway to TDE

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Removing TDE from a Database:...

Total of topN, total of other employees, total of all

By meddojeddo

I have a table which includes the columns Branch, Employee, Year, Sales and Revenue....

SSIS package to unix

By danssms

I created files from SSIS to a share folder in windows. I want to...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers