>What about something similar to this:
>
>
>SELECT TOP 3 *, INT(1000*RAND()) as _order from (your_table) ORDER BY _order
>
>
Hey Yuri.. Thanks for your repli
Nice one.. But, Jim gave me one more applicable for my needs..
Because the amount of data it is very big.. Will be something as 600.000 of 1.800.000
So the binary search will turn the query faster..
On every record I'll just record a date and some mark (this is other reason of all that I must to do is SEEK)
Thanks again..
Claudio
"Now to him who is able to do immeasurably more than all we ask or imagine, according to his power that is at work within us, Ephesians 3:20