How to place A2 before A10 in a sorted query? Sorting by calculated field?

Topics: Core, Customizing Orchard
Jul 24, 2015 at 11:30 AM
Edited Jul 24, 2015 at 11:31 AM

I'd like to sort my items in a query by their numbers, however the standard sort routine places item A10 always before the item A2.

A solution could be creating virtualy in runtime a calculated property/field converting A2 to A02 and sort by this property/field.

Is there an explanation or example, how to create such a custom sorter?

Thanks for your help and thanks for the great product!