I have need to sort the column on the left in a NUMERIC 1,2,3 vs. 1,10,11,12,2,3,

ALL-1 would become ALL-001
ALL-13A would become ALL-013A
FLR-96LF would become FLR-096F
ZI-1A would become ZI -001A

In a SP on my server how would I get this output?

TIA