Sorting Strings

Lets say I have the following strings in my database (I can use use mysql/or ms access, whicher would make this easier)

2-10
5-1
5-110
3-FC797
10-FC797S
52-FCDEMO800

How would I order these from left to right in alpha-numerical order? Should I convert the field to something else? Right now its text. I want my query to sort like this:

2-10
3-FC797
5-1
5-110
10-FC797S
52-FCDEMO800

Thanks for help!

You will not get that using ORDER BY DESC or ASC because 1 and values with one will always bee before two in ASC and after two in DESC. You could create your own hash key and order by that.