UFN_ENTITLEMENTCACHE_GET

            CREATE function dbo.UFN_ENTITLEMENTCACHE_GET
            (
                @ENTITLEMENTTYPE nvarchar(255)
            )
            returns nvarchar(255)

            with execute as caller
            as begin

                declare @VALUE nvarchar(255);

                select @VALUE = ENTITLEMENTID
                from dbo.ENTITLEMENTCACHE
                where ENTITLEMENTTYPE = @ENTITLEMENTTYPE;

                return @VALUE;

            end