<> (Not Equal To)
SQL Server 2000
Compares two expressions (a comparison operator). When you compare nonnull expressions using this operator, the result is TRUE when the left operand is not equal to the right operand; otherwise, the result is FALSE.
Syntax
expression < > expression
Arguments
- expression
- Is any valid expression in Microsoft® SQL Server™ 2000 Windows® CE Edition (SQL Server CE). Both expressions must have implicitly convertible data types. The conversion depends on the rules of data type precedence.
Result Types
bit
Examples
The following example uses the not equal to comparison operator to find all orders in the Order Details table of the Northwind database with quantities not equal to 100 units.
SELECT * FROM "Order Details" WHERE Quantity <> '100'
