Natural (human alpha-numeric) sort in Microsoft SQL 2005

order by LEN(value), value

Not perfect, but works well in a lot of cases.

Leave a Comment