Returns true if the first argument is equal to the second argument. Equivalent to the = operator.

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.

 

Output: If the value in the errorCount column is zero, then the status column value is ok. Otherwise, the value is Error_recorded


ArgumentRequired?Data TypeDescription
value1YstringThe first value. This value can be a String, a number, a function, or a column reference.
value2YstringThe 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.

Required?Data TypeExample Value
YesColumn reference, function, or numeric or String valuemyColumn

Example - Basic Equal and Notequal Functions