Technical Article

User defined function to parse delimited strings

This UDF parses a comma delimited string and returns a table with the parse strings as rows. Usage:  select * from fn+PareseString('12,13,14,67')Will return a table with the following rows12131467Can be modified to have an additional parameter for the type of delimiter.

You rated this post out of 5. Change rating

2002-05-07

836 reads

Blogs

Using a tnsnames.ora file with the Microsoft Connector for Oracle in SSIS

By

One of the nice things about the Microsoft Connector for Oracle is that it...

ChatGpt Experiments–Getting Documentation

By

I get asked questions by salespeople all the time. Usually this is because a...

A New Word: Jouska

By

jouska – a hypothetical conversation that you compulsively play out in your head –...

Read the latest Blogs

Forums

Azure SQL Revealed: A Guide to the Cloud for SQL Server

By Site Owners

Comments posted to this topic are about the item Azure SQL Revealed: A Guide...

Refresh Limits

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Refresh Limits

How Many Days Can You Survive?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Many Days Can You...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Refresh Limits

See possible answers