Dear Experts

I have a table entitled "Table1" containing following fields

sno n(3)
name c(20)

Data in Table1 is as

2 eric
3 mike
3 gagnon
3 robert
1 danial
4 romani

I want to replace sno, first field, with digits from 1 to !eof() but on every unique occourance as

1 eric
2 mike
2 gagnon
2 robert
3 danial
4 romani

I mean the data of second field, name, must not change its order only first field should replace.

Please help