UFN_REGISTRANT_GETDESCRIPTION

            create function dbo.UFN_REGISTRANT_GETDESCRIPTION
            (
                @ID uniqueidentifier
            )
            returns nvarchar(500)
            with execute as caller
            as begin
                declare @DESCRIPTION nvarchar(500)

                select
                        @DESCRIPTION = dbo.UFN_EVENT_GETNAME(REGISTRANT.EVENTID) + ' - ' +
                                        dbo.UFN_REGISTRANT_GETNAME(REGISTRANT.ID)
                from
                    dbo.REGISTRANT
                where REGISTRANT.ID = @ID

                return isnull(@DESCRIPTION,'');
            end