If your SQL Server database version is 2016 and above, a ready-made STRING_SPLIT function will come automatically. But if you have a SQL Server database under it, including 2014, you will never have ...

How to create function for split string in sql function accepts two parameters first the concatenated string and second the delimiter character.create function [dbo].[split](@string ...