General information
Title:
Replace sno with a sequence
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only