UFN_PROGRAM_GETNAME

            create function dbo.UFN_PROGRAM_GETNAME(@ID uniqueidentifier)
            returns nvarchar(100)
            with execute as caller
            as begin
                    declare @PROGRAMNAME nvarchar(100);

                    select 
                        @PROGRAMNAME = NAME
                    from dbo.PROGRAM
                    where ID = @ID;
                return @PROGRAMNAME;    
            end