SQL Server:Function to Split String Value Using Different Delimiters

In this post, I am sharing a function to split a string by using a different type of delimiters in SQL Server.

I have created this function because splitting a string is a very common requirement for all SQL Server Database Developer.

I have created this function in such a way that you guys can pass any delimiter and split your string.

This is a function:

Sample Execution:

The Result:

String Split Sql Server

Anvesh Patel

Leave a Reply

1 Comment on "SQL Server:Function to Split String Value Using Different Delimiters"

Notify of
avatar
Sort by:   newest | oldest | most voted
kavin
Guest

Hi i am kavin, its my first occasion to commenting anyplace, when i read this post i thought
i could also create comment due to this good post.

wpDiscuz