fnFundraiserTeamRegistrant

        CREATE FUNCTION [dbo].[fnFundraiserTeamRegistrant]
            (    
            @SolicitorID int
            )
            returns nvarchar(4000)
            AS
            BEGIN
                DECLARE @Registrant nvarchar(4000)
                DECLARE @RecruiterID int


                select @RecruiterID = RecruiterID from FundraiserSolicitors 
                where ID = @SolicitorID

                if @RecruiterID is null
                    begin
                        select @Registrant = cu.FirstName + ' ' + cu.LastName
                        from dbo.ClientUsers cu inner join dbo.fundraiserSolicitors frs
                        on frs.ClientUsersID = cu.ID
                        where frs.ID = @SolicitorID
                    end
                else
                    begin
                        select @Registrant = cu.FirstName + ' ' + cu.LastName
                        from dbo.ClientUsers cu inner join dbo.fundraiserSolicitors frs
                        on frs.ClientUsersID = cu.ID
                        where frs.ID = @RecruiterID
                    end

                return @Registrant
            END