Updating Sort Order on a field?

[vkunirs]

Hi

i have a customer table. i am displaying them in sorted order. but now i
have added 1 field call SortID.
now when ever if i add a new entry ...i want to sort it and i want to assign
the sorted it for that.

ex:

aaaa > 1
bbb > 2
ccc > 3

if i add aaa1 ..then its sort has to become 2 and goes one....

how to update this...using and update command....

thx in adv.

[Dan Bracuk]

What are you doing with this SortID field that you can't do with whatever field contains aaaa, aaa1, etc?

[paross1]

Your method is likely doomed to failure, and you will probably end up spending
an inordinate amount of resources attempting to "re-sort" your data. Like Dan
is implying, if you can determine what the sort order is from information in
the other columns of the table, why on earth do you need a SortID column?

Phil