>This is one interesting behavior.
>
>SELECT NAME,MESSAGE FROM MESSAGE ORDER BY 2 DESCENDING TOP 50 INTO CURSOR TEMP
>
>The question is:
>
>Do you think we will have the first 50 name having the highest number of message or not?
>
>My result is given 51 because I have 3 people having the same number of message from 49, 50 and 51 ranked.
>
>How can we use TOP 50 and have only the first 50?

Maybe a 'tiebreaker' field in the order by? The SQL is doing as it should, it doesn't want to arbitrarily choose one name over another...