Unequality <>

Operator: <>

The Unequality <> operator is used to compare two values and to check whether these values are not equal. The <> operator can be used to compare values of any type - though the compared values must be of the same type -

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

The result of the <> operator is a Yes/No. The result is Yes when compared values are not equal. The result is No when compared values are equal.

value1 <> value2

37 <> 7 => Yes

"Some Text" <> "Some other Text" => Yes

Now() <> Today() => Yes

false <> true => Yes

1234 <> 1234 => No

"1234" <> 1234 => expression type mismatch