• Remi,

    Will this work without a table/index scan?

    where datediff(d, Getdate(), date_column) = 0