If getnow() > today 4 PM Then SELECT * FROM table WHERE MailDate is Tomorrow Else SELECT * FROM table WHERE MailDate is Today
select * from table where DATEDIFF(day,GETDATE(),maildate) = case when DATEPART(hour,GETDATE()) >= 16 then 1 else 0 end
