My products usually start with a letter prefix and then a number. The problem I am having is that the numerical sort order is not correct. As an example the present sort order is C127, C12A, C131.

How can I have the sort order by number only so that the order will be C12A, C127, C131?