ramlicious Blogs by Tina & Prabhu

October 7, 2010

Character-separated List of Row values (with Delimiter as parameter)

Filed under: SQL Server — Prabhuram @ 7:28 am

A minor correction to fn_ConvertCSVToTable posted in Character-separated List to Row Values is available here for download: fn_ConvertCSVToTable.sql (730.00 bytes), which can be called as below:

select * from dbo.fn_ConvertCSVToTable ('1,2,3,4,5,6,7,8,9,0', ',') Numerals 

to return values as rows. The delimiter is also available as a parameter.

No Comments

No comments yet.

RSS feed for comments on this post.

Sorry, the comment form is closed at this time.

Powered by WordPress