Home Library Learn Downloads Support Community
Sign in | United States - English | |
This topic has not yet been rated - Rate this topic

!< (Not Less Than) (SQL Server Compact)

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

Copy 

expression ! < expression
expression

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

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

Copy 
SELECT * FROM "Order Details" WHERE Quantity !< '100'
Did you find this helpful?
(1500 characters remaining)