declare @a datetime set @a='2012-05-01' select convert(varchar(7),@a,120) select * from Tabl where convert(varchar(7),@a,120)>= convert(varchar(7),PurchaseDate,120)