I have a table which contains varchars with numbers in them such as "03-011A" or "03.011A" or "03-011" or "03.011" etc...
However, standard methods of numerical order seem ineffective and they still return unordered, I've checked for solutions but alas, I have found no cure.

Got any ideas?