Comparison Operators
Use comparison operators to compare character or numeric strings, manipulate data, and return a TRUE (1) or FALSE (0) value.
The following table lists the transformation language comparison operators:
Operator | Meaning |
|---|
= | Equal to. |
> | Greater than. |
< | Less than. |
>= | Greater than or equal to. |
<= | Less than or equal to. |
<> | Not equal to. |
!= | Not equal to. |
^= | Not equal to. |
Use the greater than (>) and less than (<) operators to compare numeric values or return a range of rows based on the sort order for a primary key in a particular field
When you use comparison operators in an expression, the operands must be the same datatype. For example, the expression 123.4 > ‘123’ is not valid because the expression compares a decimal with a string. The expressions 123.4 > 123 and ‘a’ != ‘b’ are valid because the operands are the same datatype.
If you compare a value to a null value, the result is NULL.
If a filter condition evaluates to NULL, Informatica Cloud returns NULL.