I could see possibly A000 but not 000A. Switching from base 10 to base 16 or
whatever base you ultimately settle on, you should keep the same counting
sequence. For example 0 1 2 3 4 5 6 7 8 9 a b c d e f g h i j k l m n o p
before you switch to the next digit 10. And if you do not sort the item then
you can do whatever you want with the value.

James

-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]]On
Behalf Of [log in to unmask]
Sent: Wednesday, October 13, 1999 7:33 AM
To: [log in to unmask]
Subject: Counting from 9999 to 000A?


Dear listers

I am looking for an algorithmus, which solves the following problem and
could be used within POWERHOUSE.

We have an identifier which ranges from 1-9999 (but is stored as character
in the database). We are about to reach the limit, so I would like to store
000A after 9999 and so on, rather then changing all the database structures
and depending programs.

Thank you for any help,
Friedrich