Comparison Search Conditions
Microsoft SQL Server uses these comparison operators.
Greater than or equal to
Less than or equal to
Not equal to (ISO compatible)
Not greater than
Not less than
Not equal to
Comparison operators are specified between two expressions. For example, to retrieve the names of only those products for which the list price is greater than $50, use:
SELECT Name FROM AdventureWorks2008R2.Production.Product WHERE ListPrice > $50.00;
When you compare character string data, the logical sequence of the characters is defined by the collation of the character data. The result of comparison operators such as < and > are controlled by the character sequence defined by the collation. The same SQL Collation might have different sorting behavior for Unicode and non-Unicode data. For more information, see Working with Collations.
Trailing blanks are ignored in comparisons; for example, these are equivalent:
WHERE LastName = 'White' WHERE LastName = 'White ' WHERE LastName = 'White' + SPACE(1)
The use of NOT negates an expression. For example, this query finds all products that have a list price of $50 or more, which is logically the same as asking for all products that do not have a list price of less than $50:
SELECT ProductID, Name, ListPrice FROM AdventureWorks2008R2.Production.Product WHERE NOT ListPrice < $50 ORDER BY ProductID;