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.
.gif)
Transact-SQL Syntax Conventions
-
expression
-
Is any valid expression. Both expressions must have implicitly convertible data types. The conversion depends on the rules of data type precedence.
Boolean
Reference
Data Types (Transact-SQL)
Operators (Transact-SQL)
Other Resources
Comparison Operators (Database Engine)
Help and Information
Getting SQL Server 2008 Assistance