XtiaN asked: >>can anyone help me ? >>select * From ( >>SELECT top 100 PERCENT a,b,c >>FROM tb >>WHERE DATEDIFF(day, b ,getdate())>=3 >>order by b desc) asd >>union all >>select * From ( >>SELECT top 100 PERCENT a,b,c >>FROM tb >>WHERE DATEDIFF(day, b ,getdate())<3 >>order by b asc) def Hi XtiaN, I think we have some folks who can help. However, we might want to crosscheck and make sure we understand what you want. Do you really want a list of "Records that are more than 3 days old descending by datetime stamp" added to a list of "Records that are less than 3 days old ascending by datetime stamp"? So if we run this query at 2pm on 18-Oct-2007 we _want_ to see something like this???: (Record 1) 15-Oct-2007 2pm (Record 2) 14-Oct-2006 1pm (Record 3) 11-Oct-2005 6pm (...) (Record n) 15-Oct-2007 3pm (Record n+1) 15-Oct-2007 7pm (Record n+2) 16-Oct-2007 4am It just seems like a really odd thing to ask for. I think if we better understand what you want the result to look like, we can help get there. Thanks, RonL.