Not Equal Operator
Description: Tests two operands and returns TRUE if the two values are not equal. The two operands must be of the same type. Integer, float, and string, data types are eligible for comparison. Related Loader cannot create an index based on this operator.
Symbol: !=
Example:
32!=15 returns TRUE
32!=32 returns FALSE
Salary!=50000 in a source field would place a 1 in each target fields with values not equal 50000 and a 0 for all values which equal to it.
Placement: Source field: See "Example" above.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*