>= (Greater Than or Equal To) (Transact-SQL)
SQL Server 2012
Compares two expressions for greater than or equal (a comparison operator).
When you compare nonnull expressions, the result is TRUE if the left operand has a greater or equal value than the right operand; otherwise, the result is FALSE.
Unlike the = (equality) comparison operator, the result of the >= comparison of two NULL values does not depend on the ANSI_NULLS setting.
A. Using >= in a simple query
The following example returns all rows in the HumanResources.Department table that have a value in DepartmentID that is greater than or equal to the value 13.
USE AdventureWorks2012; GO SELECT DepartmentID, Name FROM HumanResources.Department WHERE DepartmentID >= 13 ORDER BY DepartmentID;
Here is the result set.
DepartmentID Name ------------ -------------------------------------------------- 13 Quality Assurance 14 Facilities and Maintenance 15 Shipping and Receiving 16 Executive (4 row(s) affected)