Function for getting comma seperator

reate

function [dbo].[CommaSeperator]
(

@stringToBreak varchar

(4000),
@limiter

char(1)
)

returns @list

table (item varchar(4000))
as

begin


if (charindex(@limiter,@stringToBreak) = 0)

begin

insert into @list values (@stringToBreak)

return

end

declare @list1 varchar(4000)

declare @charIndex int

declare @TempItems table (item varchar(4000))

set @charIndex = charindex(@limiter,@stringToBreak)

while len(@stringToBreak) > 0 and @charIndex <> 0

begin

select @list1 = ltrim(left(@stringToBreak,@charIndex - 1))

insert @tempItems select @list1

select @stringToBreak = ltrim(right(@stringToBreak, len(@stringToBreak) - @charIndex))

set @charIndex = charindex(@limiter,@stringToBreak)

end

insert @tempItems select @stringToBreak

insert @list select Item from @tempItems

return
end