CREATE FUNCTION getPurchaser(@porid DECIMAL(20,0)) returns varchar(100) as begin declare @str varchar(100) declare @temp varchar(20) declare cur cursor for select distinct purchaser from re_purchaser where porid = @porid set @str = '' set @temp = '' open cur fetch next from cur into @temp while(@@fetch_status = 0) begin set @str = @str + @temp + '/' fetch next from cur into @temp end close cur deallocate cur set @str = substring(@str,0,len(@str)) return @str end