Syntax
Description
Checks to see if two values are different by comparing the arguments of one column with the arguments of another column. Both columns must contain the same data type. NOT_EQUALS then returns a Boolean value, either true if both arguments are different or false if the arguments are equal. If one of the arguments is null, NOT_EQUALS returns true.
Examples
Data field type | Column1 | Column2 | NOT_EQUALS returns |
---|---|---|---|
15 | 35 | true | |
23 | 23 | false | |
Integer | 23 | null | true |
7.6 | 7.6 | false | |
8.6 | 15.3 | true | |
Float | 15.3 | null | true |
Aug 2, 2011 3:55:03 PM | Oct 15, 2010 4:34:34 AM | true | |
Mar 2, 2002 1:24:12 PM | Mar 2, 2002 1:24:12 PM | false | |
Date | null | Oct 15, 2010 4:34:34 AM | true |
false | true | true | |
true | true | false | |
Boolean | null | true | true |
Germany | George | true | |
George | George | false | |
String | German | null | true |
null | null | false |
Instead of using a function, you could also use the equality operator !=.