Order By SQL Problem

[Bmasephol]

I'm storing numbers as text in an Access DB so that I can have the number 00 show up. I'm building a Sport Roster page. Anyways I want to sort the page by jersey number and by last name but I run into a problem when I do an ORDER BY jersey because it returns the jersey numbers like this... 0, 00, 1, 10, 11, 2, 3, 4, 5, 6 ....

I can't figure out how to return the them like this... 0, 00, 1, 2, 3, 4, 5.... 9, 10, 11, 12, ...

Anyone out there can give me a hand?

Thanks
Bryan

[Lars_Berg]

order by clng(jersey),jersey

[Bmasephol]

Fast, Efficient, and it WORKS.

Thank You very Much 🙂