Numeric Sort with Trailing Zeros

[Gsrgofass]

Hello,

I have a serial number column in my database where the leading and last number of the 6 digit number represents the YOM (year of manufacture) of the machine. I have it formatted as 'Special' in order to display a leading zero for 2020 models.
When doing a general search for a range of serial numbers choosing 'Smallest to Largest' is a popular choice.
Ex:
019742 (2020 YOM)
793821 (2017 YOM)
803061 (2018 YOM)
915471 (2019 YOM)

If I sort 'Smallest to Largest', I get the order as you see above. 2020 listed prior to any other year. When 2021 hits, I will have years 2019 and then see 2021 serial number with 2020 still at the top of the list.

Is it possible to sort but have the leading 0 come after a leading 9 and then allow the next leading number to be a 1, 2.... and so on?
793821 (2017 YOM)
803061 (2018 YOM)
915471 (2019 YOM)
019742 (2020 YOM)
115202 (2021 YOM)
213302 (2022 YOM)
etc....

 

[Fluff]

OK, glad we could help & thanks for the feedback.