Comparison Operators

The table below lists the Comparison Test syntax that can be used in message selectors (based on the SQL-92 SELECT statement syntax):

Element	Syntax and Specifications
IN	Identifier IN (str1, str2,…) Identifier NOT IN (str1, str2,…)
LIKE	Identifier LIKE (str1, str2, …) Identifier NOT LIKE (str1, str2,…) Can be enhanced with pattern values: Underscore (_) stands for any character Percent % stands for any sequence of characters To explicitly defer the special characters _ and %, precede their entry with the Escape character.
NULL	Identifier IS NULL Identifier IS NOT NULL For: header field value property value existence of a property

An example of IN usage is:

 country IN ('US','UK','India') 

An example of LIKE usage is:

 state LIKE 'TN' is true for 'Athul' 'Aditya' and false for 'Kalyan' 

An example of null usage is:

 x IS NULL