Example: Creating Profile that Ignores pair-name with Any pair-value - Teradata Vantage

This example specifies the name IMPORTANCE without a value, that is, an empty string. This causes a SET QUERY_BAND statement to discard the name-value with the matching name and any value.

    CREATE PROFILE testprofile AS
          IGNORE QUERY_BAND VALUES = ‘IMPORTANCE=;’;