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*