Comparison operators are used to compare the value of two expressions, returning True if the comparison succeeds, and False if it does not. The following rules apply to the use of comparison operators handled by the Integration service:
For numeric data types, the usual rules of arithmetic comparisons apply.
For string comparisons, the shorter of the two strings is padded with space characters to equal the length of the longer string before the comparison is performed, as in SQL-92.
Timestamps are compared using chronological order.
An equality comparison between two floating point numbers does not return an error.
Comparison operations delegated to a remote data source may vary from the rules for comparison operators handled by the Integration service.
For numeric data types, the usual rules of arithmetic comparisons apply.