Comparison Search Conditions

Microsoft SQL Server uses these comparison operators.




Equal to


Greater than


Less than


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:

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