Hi.
I am trying to create a SQL statement that sorts by a column that
contains a mix
of numbers and periods, but it doesn't seem to work properly.
The statement I use is:
SELECT ItemNumber FROM Catalog ORDER BY ItemNumber
For instance, here is how the list was sorted:
5.2.8
5.2
5.3
5.13
5.10
Hi.
You cannot change the sorting behaviour of MySQL to achieve what you
want.
There are several possible work-arounds, though. One is to save the
numbers in a way (inserting zeros) that sorting will work, if that is
feasible:
5.10
5.13
5.02
5.02.08
5.03
5.27
If the depth (here: 3) of