Claudio,

You could do something like this:

RAND(-1)

SELECT TOP 3 RaffleNumber, RAND() AS SortOrder ;
  FROM Raffle ;
  ORDER BY SortOrder

HTH,
Chad

>>Hello
>>
>>I need to create a procedure to raffle (randon) N records (by it keys) among the area/records in a table..
>>
>>For example.. I'd like to get 3 randon items of the list below.. Different on each time that I run my procedure..
>>
>>00000124
>>00000334
>>00000454
>>00000455
>>00001888
>>00001993
>>00030001
>>00045540
>>00012222
>>00344445
>>00554442
>>
>>Does anyone could help me on it, please ?
>>
>>TIA
>>
>>Claudio