Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

>= (Greater Than or 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 has a value higher than or equal to the right operand; otherwise, the result is FALSE.

expression > = 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



The following example uses the greater than or equal to comparison operator to find all orders in the Order Details table of the Northwind database with quantities equal to or more than 100 units.

SELECT * FROM "Order Details" WHERE Quantity >= '100'

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
© 2015 Microsoft