Example: Creating Profile that Ignores pair-name with Any pair-value - Advanced SQL Engine - Teradata Database

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=;’;