IS

Search condition, typically "NULL," "TRUE," "UNKNOWN," and "FALSE."

IS is used in complex search conditions. The more complex the search, the more useful the IS condition can be. These Boolean search conditions provide an alternative way of expressing the basic search conditions.

This macro is available in IBM® Unica® Interact.

IS returns different results in IBM® Unica® Interact from IBM® Unica® Campaign. NULL returns 1 if there is at least one NULL value for an audience id. UNKNOWN returns 1 for an audience id if it doesn't have any value.

Examples

SELECT customer FROM customer_table1 WHERE (last_name = "Smith" AND first_name = "John") IS TRUE ;

will produce a list of all customers having the name John Smith.

SELECT customer FROM customer_table1 WHERE (last_name = "X" AND first_name = "X") IS UNKNOWN ;

asks for any non-null value.

SELECT cost FROM cost_table1 WHERE (current_cost = "200" IS FALSE ;

lists all values from the cost table that are not $200.