SQLStr="SELECT TOP 10 * FROM ORArticles WHERE featured = 1 and MagID = 16"

I have this code, and I have ten articles that are featured(featured = 1), but it only picks the first one, I want it to pick a random article everytime out of the top 10. what do I need to add to the code to have it choose a random aritcle from those 10?

Thanks

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

What is your database platform? If you are using MSSQL you could do this:

SELECT TOP 1 * FROM ORArticles WHERE featured = 1 and MagID = 16 ORDER BY NEWID()

NEWID() will generate a new GUID for every row selected and because GUIDs are kinda-sorta randomish you'll get a "random" row.

Peter
------------------------------------------------------
Work smarter, not harder.

That works great, thank you!