UFN_CONSTITUENTSEARCH_DISPLAYNAME

            CREATE function dbo.UFN_CONSTITUENTSEARCH_DISPLAYNAME(@ID uniqueidentifier)
            returns nvarchar(700)
            as begin
                if @ID is null
                    return '';

                return (
                    select NF.NAME
                    from dbo.UFN_CONSTITUENT_DISPLAYNAME(@ID) NF
                );
            end