UFN_DONORCHALLENGE_GETNAME

                create function dbo.UFN_DONORCHALLENGE_GETNAME(@ID uniqueidentifier) returns nvarchar(50) 
                as
                begin

                    declare @NAME nvarchar(100);

                    select 
                        @NAME = NAME 
                    from 
                        dbo.DONORCHALLENGE 
                    where ID = @ID;

                    return @NAME;
                end