UFN_PROSPECTFUNDINGINTEREST_GETNAME

            create function dbo.UFN_PROSPECTFUNDINGINTEREST_GETNAME
            (
                @ID uniqueidentifier
            )
            returns nvarchar(154)
            with execute as caller
            as
            begin
                declare @FUNDINGTYPE nvarchar(154);
                select 
                    @FUNDINGTYPE = dbo.UFN_FUNDINGTYPECODE_GETDESCRIPTION(PROSPECTFUNDINGINTEREST.FUNDINGTYPECODEID) + ' (' + PROSPECTFUNDINGINTEREST.INTERESTLEVEL + ')'
                from
                    dbo.PROSPECTFUNDINGINTEREST
                where
                    ID = @ID

                return coalesce(@FUNDINGTYPE, '');
            end