I added a new extra field to my fogbugz database, to track the importance of a case, more than just the priority. I considered it a numeric field, but when ordering, it is ordered like a text field.
Is there any way to implement "natural ordering" of this field? ie. keep text ordering, but handle numbers correctly?
This is typically what has to be done to order file names for instance, ie. "file 1.txt"..."file 29.txt", where the numbers are not the same length etc.
