SELECT where date is greather then code example Example: query less than datetime sql select * from dbo.March2010 A where A.Date >= '2010-04-01'