I've got a little problem with my MySQL query for sorting my products. The query is simple "ORDER BY itemcode ASC". Problem is it is only sorting to the first 3 digits so for example when it should display like this EA185, EA333, EA1300, EA1900 it displays EA1300, EA185, EA1900.
Is there another way to get them to sort properly? I've noticed `Sage` (accounts program) does the same thing.
Keiran
Is there another way to get them to sort properly? I've noticed `Sage` (accounts program) does the same thing.
Keiran