I can't figure out how to do this.

SQLStr="SELECT TOP 10 * FROM ORArticles WHERE Featured= 0 ORDER by MagID DESC"
Set RS=Server.CreateObject("ADODB.Recordset")
RS.Open SQLStr,Application("DBConn"),adOpenKeyset,adLockPe ssimistic,adCmdText

This is my current statement, which works fine. I have one featured article that stays ontop or the day with a picture. But the next day when a new featured article comes in the one from the day before is knocked off the list.

What I want to to is, keep the featured article from the day before in the top 10 list. But I also need to make sure I don't choose the featured article from today, that's why I have featured= 0. So is there a way to use the date and say from yesterday or today's date -1 or something like that, or do I just need another sql satament that choose the featured article from the day before?

I hope this is explained right.

Thanks

__________________
-----------------------------------------------------------
\"Don\'t follow someone who\'s not going anywhere\" John Mason