I'm running a query on a table that contains a column of type varchar. Here are some example row values for this column:

001-0324
001-0125
001-0085
001-1294
001-1035

When I run a query that sorts by this column, I get them in this order:

001-0085
001-1035
001-0125
001-1294
001-0324

What I need is for them to be sorted this way:

001-0085
001-0125
001-0324
001-1035
001-1294

Anyone know why it sorts in this way? Should I be using something other than varchar?