What is the name of this <> operator?

What is the name of <> operator?

Operator nameSyntaxLess thana < bGreater than or equal toa >= bLess than or equal toa <= b

What does the <> operator mean in SQL?

Not Equal To (Transact SQL) - traditional Compares two expressions (a comparison operator). When you compare nonnull expressions, the result is TRUE if the left operand is not equal to the right operand; otherwise, the result is FALSE.

What is the use of <> operator?

OperatorPurpose> <"Greater than" and "less than" tests.>? <?"Greater than or equal to" and "less than or equal to" tests.IN"Equal to any member of" test. Equivalent to "= ANY".NOT INEquivalent to "!=ALL". Evaluates to FALSE if any member of the set is NULL.

What does this mean <>?

Yes, it means "not equal", either less than or greater than. e.g If x <> y Then. can be read as. if x is less than y or x is greater than y then.