check less than using dates in sql server code example Example: query less than datetime sql select * from dbo.March2010 A where A.Date >= '2010-04-01'