Hi all, I have a number which I increment each time an entry is entered into the database, I’m sorting the column by DESC which is kind of working but KK10 isn’t at the top, it’s above KK1 and below KK2. What can I do to rectify this issue? I’ve tried using MAX(receipt_id) but that just returns KK9. Any help is appreciated as always 
ORDER BY CAST(SUBSTRING(receipt_id FROM 3) AS UNSIGNED) DESC
Hi r937, that’s done the job nicely. Absolute massive help. Thank you so much dude, really appreciate it
Looking at your data, it looks to me like receipt id is composed of a code that identifies the person that added it, and a incrementing number. So maybe you could’ve sorted by addedby and id (or just id) as well.