Hello,

Consider, if you will, the following product codes:
BK1
BK1a
BK2
BK3
BK11
BK22

That would be that 'natural' order of things as far as a human is concerned.

MySQL would order them thusly:
BK1
BK11
BK1a
BK2
BK22
BK3

I can understand that logic, but how can I convince MySQL to come round to my way of thinking?

Many thanks,
M