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??
This is coz it is sorted as string, that is, if you would sort this numbers, as string, they would be sorted like this:
here is the hint:
Easier than Bubikol's suggestion:
If the values might start with other 3-letter sequences, and if you want the values in order, including the letters, as for example:
|All times are GMT +1. The time now is 09:39 PM.|
Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.