Difference between <> and NOT operator in Microsoft Access?

What might the difference between "<>" and "NOT" operator be when used in Microsoft Access?

2 Answers

NOT is a unary operator which complements its argument, eg

• NOT(TRUE) is equivalent to FALSE

In contrast <> is a binary operator which compares two values, eg

• 1<>0 is equivalent to TRUE, or to NOT(1=0)

This latter equivalence is the only sense in which the two are connected.

NOT Operator Operation involving NOT operator is known as ‘Logical Negation’. This operation is performed on only one input or operand. It returns the value of TRUE if the input is FALSE and vice-versa.Not Operator is the not true of your operation like

Not Null (is not null)
Not = (not equal)
Not In (Not Exist)
but <> is just different from any value or not = to the value

1

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy