fnFundRaiserTeamCaptain

            create function [dbo].[fnFundRaiserTeamCaptain]
                (    
                @SolicitorID int
                )
                RETURNS nvarchar(100)
                AS
                BEGIN
                RETURN (SELECT cu.FirstName + ' ' + cu.LastName FROM [dbo].[FundRaiserSolicitors] frs
                        INNER JOIN [dbo].[ClientUsers] cu ON frs.ClientUsersID = cu.ID
                        WHERE frs.ID=@SolicitorID)
                END