This documentation is archived and is not being maintained.

!> (Not Greater Than) (Transact-SQL)

Compares two expressions (a comparison operator). When you compare nonnull expressions, the result is TRUE if the left operand does not have a greater value than the right operand; otherwise, the result is FALSE. Unlike the = (equality) comparison operator, the result of the !> comparison of two NULL values does not depend on the ANSI_NULLS setting.

Topic link iconTransact-SQL Syntax Conventions

expression !>expression


Is any valid expression. Both expressions must have implicitly convertible data types. The conversion depends on the rules of data type precedence.