Here is a better solution i guess

create function dbo.split(@str varchar(100),@delimeter varchar(1)) returns @t TABLE (itemnumber int identity(1,1),val varchar(100))
begin
        declare @cursor INT =0,@prv int = 0
        while @cursor < Len(@str)
        begin
            
            set...