I have a report that lists all of our fleet in 'facilitycode' order. Like this;
The field is a string and I have found how to sort this through converting to a number. My problem is one facility code is '269.B'. I can't find a way to display in numerical order AND make allowances for letters. We will be encountering this problem a lot more and I want to get it sorted before end users launch an attack.
Appreciate any suggestions