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,…) |
LIKE | Identifier LIKE (str1, str2, …) |
NULL | Identifier IS NULL
|
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