CREATE FUNCTION GetGuestIDs (@Sign int) RETURNS varchar(6000) WITH EXECUTE AS CALLER AS BEGIN declare @GuestIDs varchar(6000) set @GuestIDs='' select @GuestIDs=@GuestIDs+','+CAST(guestid as varchar) from View_OpGuestView_ybt where signid=@Sign if len(@GuestIDs)>1 begin select @GuestIDs=substring(@GuestIDs,2,len(@GuestIDs)-1) end RETURN(@GuestIDs) END; GO