View Source

Returns true if the first argument is not equal to the second argument. Equivalent to the <> or != operator.

Each argument can be a literal String, Integer or Decimal number, a function, or a column reference.

Since the function returns a Boolean value, it can be used as a function or a conditional.

NOTE: Within an expression, you might choose to use the corresponding operator, instead of this function. For more information, see Comparison Operators.

notequal(myValue, checkSum)

Output: Returns true if the value in the myValue column does not equal the value in the checkSum column.

notequal(value1, value2)

Argument	Required?	Data Type	Description
value1	Y	string	The first value. This value can be a String, a number, a function, or a column reference.
value2	Y	string	The second value. This value can be a String, a number, a function, or a column reference.

value1, value2

Names of the columns, expressions, or literals to compare.

Missing values generate missing results.

Required?	Data Type	Example Value
Yes	Column reference, function, or numeric or String value	`myColumn`

value1, value2

Example - Basic Equal and Notequal Functions