BEGIN DECLARE @t TABLE(ID int IDENTITY, ch_apno Varchar(50)) DECLARE @result varchar(100),@flag int, @temp Varchar(20) SET @result = '' SET @temp = '' INSERT INTO @t(ch_apno) SELECT ch_apno FROM iech00d1 WHERE ch_no = @ch_no AND ch_seq = @ch_seq SELECT @flag= (SELECT TOP 1 ID FROM @t ORDER BY ID DESC) IF @flag IS NOT NULL BEGIN WHILE(@flag > 0) BEGIN SET @temp = (SELECT ch_apno FROM @t WHERE ID = @flag) IF(CHARINDEX(@temp,@result) = 0) SET @result = @result + @temp + ',' SET @flag = @flag - 1 END SET @result = SUBSTRING(@result,0,LEN(@result)) END Return @result END