SQL SPLIT FUNCTION or String_split sql function alternative Very Information (Solved)

Dear All, 

Today i created a form with the checkbox list and store the value in the sql with comma seprated way. It was strange for me that the split_string function is not supported in sql 2014, so i have created split function that will help to split the comma sepearted values 

 CREATE FUNCTION dbo.Split(@String varchar(8000), @Delimiter char(1))     

returns @temptable TABLE (items varchar(8000))     

as     

begin     

declare @idx int     

declare @slice varchar(8000)     

select @idx = 1     

    if len(@String)<1 or @String is null  return     

while @idx!= 0     

begin     

    set @idx = charindex(@Delimiter,@String)     

    if @idx!=0     

        set @slice = left(@String,@idx - 1)     

    else     

        set @slice = @String     

    if(len(@slice)>0)

        insert into @temptable(Items) values(@slice)     

    set @String = right(@String,len(@String) - @idx)     

    if len(@String) = 0 break     

end 

return     

end

select top 10 * from dbo.split('Karachi,Lahore,Islamabad',',')

I hope it will solve the problem 

Regards
Rashid Imran Bilgrami