Hello, maybe someone can help me with this:
I have a varchar column containing entries that I want to sort. Each
entry consists of a combination of letters, and an optional number.
Obviously I want these entries ordered in the human way:
alphabetically AND numerically, as above, where a-with-2 comes before
a-with-12 (since the integer 12 is larger than the integer 2).
If I use ORDER BY thiscolumn, I get this result:
that is, these ...