>>select top 14 * from myTable order by NewID()
>
>Thanks, this works.
>
>I assume this will always be optimized even on a two million records table.
No it's not. IIRC, I posted improved version in UT magazine a while ago but the link
http://www.utmag.com/ doesn't work.
--sb--