UFN_INSTALLATIONINFO_GETPRODUCT

            create function dbo.UFN_INSTALLATIONINFO_GETPRODUCT()
            returns nvarchar(100)
            with 
            execute as caller
            as 
            begin
                declare @PRODUCT nvarchar(100)
                select
                    @PRODUCT = PRODUCT
                from dbo.INSTALLATIONINFO
                where ID = 1

                return @PRODUCT
            end