oK.....Did some further testing.
Seems if there are say 6 records with the same value, it returns all 6

Gerard


>I have following command:
>SELECT TOP 2 REP FROM MyTable ORDER BY REP
>
>However this returns 6 records.
>I was expecting just 2.
>Tia
>Gerard