Sort Order for varying length string.
I have searched for an answer but can't even find a starting point.
I have a list of order number based on a prefixed date stamp:
ORD201302161, ORD201302162, ORD201302163, ORD201302164, etc.
The display is sorted using ASC, however they do not display as I would expect them to:
How can I sort the order correctly??