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 



Professional JMS
Professional JMS
ISBN: 1861004931
EAN: 2147483647
Year: 2000
Pages: 154

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net