SQL Less Than Comparison Operator

The SQL Less Than comparison operator (<) is used to compare two values.  It returns TRUE if the first value is less than the second.  If the second is less, it returns FALSE. 

You can also test for Less than or equal to by using <=.  

Here are a couple of examples: 

SELECT ProductNumber, Name, ListPrice 
From Production.Product 
Where ListPrice < 100

SQL Less Than with Other Types 

You can use the Less than comparison with other data type, such as String and DateTime. 

Here we’re returning products modified before February 15^th, 2014. 

SELECT ProductNumber, Name, ListPrice, ModifiedDate 
From   Production.Product 
WHERE  ModifiedDate < '2014-02-15' 

Additional Resources 

To learn more about SQL Less than (<), check out these useful resources: 

• How to Filter Query Results 
• Introduction to SQL Servers Built-In Logical Functions 
• Recommended book SQL Practice Problems: 57 beginning, intermediate, and advanced challenges for you to solve using a “learn-by-doing” approach