!> (Not Greater Than) (SQL Server Compact Edition)

Compares two expressions. When you compare nonnull expressions using this operator, the result is TRUE when the left operand does not have a value higher than the right operand. Otherwise, the result is FALSE.

Syntax

expression ! > expression

Arguments

  • 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.

Result Types

bit

Example

The following example uses the not greater than comparison operator to find all orders in the Order Details table with quantities equal to or less than 10 units.

SELECT * FROM "Order Details" WHERE Quantity !> '10'