question about sorts in a custom collection

[Robby Stephenson]

On Wednesday 24 September 2008, Peter Alcibiades wrote:
> That is, the records are in increasing order of the date plus suffix,
> where increasing means that DDDD.100 is higher than DDDD.11.   And
> DDD.1.4.4 if there were one would be higher' than DDDD.1.4.

There's no natural sort available. Tellico has title-sorting, LCCN-sorting, 
numerical-sorting, and a few others for fields, but no natural. I think 
KDE4 actually added a class for that, maybe I could use it.

> It is an object lesson in why not to make your index field out of
> something with meaningful data when constructing databases, and it might
> be that the only way to fix this is to insert another field, which is
> just a sequential auto incrementing serial number, and then use that to
> sort by.  Or maybe there is a way to use table fields and split the
> elements of the field?

I can't think of anything short of editing the original data.

Robby