05-26-2014, 08:42 AM
polanskiman Wrote:The only way at present to do this in a clean way so that the records ID are properly ordered is simply not to put any prefix, or add x amount of 0s in the Start Sequence field prior the initial number.
The only way to do it is "adding x amount of 0s", I don't think that ommiting the prefix will help. In any case, I don't see much of an issue about sorting with a given amount of 0x in place, in fact, I personally like it as it gives all records a consistent size.
I understand that you would like to have the records ordered by prefix and then numerically. right?
Joe
TSolucio
TSolucio