Support "natural sorting" / DIGITSASNUMBERS as a Collation option
Quite often** people want to sort a string containing either only numbers, or a mix of letters and numbers in a pattern, such that the numeric portion of that string is sorted as an actual number. For example, "Class40g" would come before "Class300c", not after. This behavior has already been integrated into File Explorer, starting in Windows 7.
Currently when people need to do this type of sorting, they need to create silly and inefficient methods of parsing the string into separate alpha and numeric chunks.
** often = numerous questions regarding how to accomplish this type of sorting on MSDN Forums, StackOverflow, DBA.StackExchange, etc.
Upvotes: 11<=-=Jul 15 2016 6:51AM=-=>
I offer as evidence for the desire for this to happen, the 1k+ views of my stackoverflow question from 2011. A little under a person a day.
Adding to the link that Justin posted to his Stack Overflow question:
We understand the scenario and if it gets more votes we will consider it for the next releases. It is assigned to our collation & string processing team.
Solomon Rutzky commented
I originally submitted this suggestion via: