I want to do an automatic computer drawing for certain people, I puted all the records in a cursor including how many times they have a chance to win, each chance is a seperate reocrd, what is the best method that it should pick random records ?, I worked with RAND(), I added a numeric field named no then I did

RAND(-1)
REPLACE ALL no WITH RAND()*1000

then I did select top 1 from cursor order by no

Can anyone advise me if with that way is it really random so I can be sure that the drawing is fare ?

Any help will be greatly apriciated.

Simon