SQL Server:Function to Split String Value Using Different Delimiters

In this post, I am providing one function to split string by using 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 type of delimiter and split your string.

This is a function:

Sample Execution:

The Result:

String Split Sql Server

Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

If you like this post, then please share it with others.
Please follow dbrnd.com, I will share my experience towards the success of Database Research and Development Activity.

I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.

More from dbrnd.com

Leave a Reply

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

Notify of

Sort by:   newest | oldest | most voted
9 months 10 days ago

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.