IS
Syntax
IS <keyword>
Parameters
keyword
Search condition, typically "NULL," "TRUE," "UNKNOWN," and "FALSE."
Description
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 ;
SELECT customer FROM customer_table1 WHERE (last_name = "X" AND first_name = "X") IS UNKNOWN ;
SELECT cost FROM cost_table1 WHERE (current_cost = "200" IS FALSE ;