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. If either or both operands are NULL, see the topic SET ANSI_NULLS (Transact-SQL).
.gif)
Transact-SQL Syntax Conventions
expression < > expression
-
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)
Comparison Operators (Transact-SQL)
Help and Information
Getting SQL Server 2008 Assistance