Hi, Steven!
One simple way is:
- Create a table with two fields: cRealName and sSortOrder.
- Fill in all possible combinations and related sortorders.
- Join this table to your original table and use the sortorder field!
The other idea is to create two functions:
- One function to calculate the next revision from an existing revision.
- Another function to convert the revision into a sorted manner for usage in SQL statements like "SELECT GetSortId( Revision ) AS SortField.
SeBaFlu