Export (0) Print
Expand All
Expand Minimize
5 out of 6 rated this helpful - Rate this topic

<> (Not Equal To) (SQL Server Compact Edition)

Compares two expressions. When you compare nonnull expressions by using this operator, the result is TRUE when the left operand is not equal to the right operand. Otherwise, the result is FALSE.


expression < > expression
expression

Any valid expression in Microsoft SQL Server 2005 Compact Edition. Both expressions must have implicitly convertible data types. The conversion depends on the rules of data type precedence.

The following example uses the not equal to comparison operator to find all orders in the Order Details table with quantities not equal to 100 units.

SELECT * FROM "Order Details" WHERE Quantity <> '100'
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.