Microsoft SQL Sample Code
Function for Splitting a String with a Common Delimiter
This SQL Server/Azure function is very useful for taking of string of data that has a common delimiter and returning it in a table format.
A sample call to this function would be:
Select * from dbo.wsiSplit('test,test2,test3,test4',',')
which would return:
If you need any help implementing this
function or modifications made for your needs, please
Click Here to get a free
quote for your Microsoft
SQL Development needs.
Click Here to learn more
about the WSI quoting