UFN_EVENTPRICE_GETNAME

                create function dbo.UFN_EVENTPRICE_GETNAME
                (
                    @ID uniqueidentifier
                ) 
                returns nvarchar(100)
                with execute as caller
                as
                begin
                    declare @NAME nvarchar(100);
                    select @NAME = [EVENTPRICE].[NAME] from dbo.EVENTPRICE where [EVENTPRICE].[ID] = @ID;
                    return @NAME;
                end