UFN_LIKELIHOODPERCENT_GETNAMEANDPERCENT

            create function dbo.UFN_LIKELIHOODPERCENT_GETNAMEANDPERCENT
            (
                @ID uniqueidentifier
            )
            returns nvarchar(110)
            with execute as caller
            as
            begin
                declare @NAME nvarchar(110);
                select
                    @NAME = LIKELIHOODTYPECODE.DESCRIPTION + 
                        case when LIKELIHOODPERCENT.[PERCENT] is not null 
                            then ' (' + convert(nvarchar(3), LIKELIHOODPERCENT.[PERCENT]) + '%)'
                            else '' end
                from 
                    dbo.LIKELIHOODTYPECODE
                    left join dbo.LIKELIHOODPERCENT on LIKELIHOODTYPECODE.ID = LIKELIHOODPERCENT.ID
                where
                    LIKELIHOODTYPECODE.ID = @ID

                return @NAME;
            end