Sorting SQL char field types

I did it. Access requires that the field's values be sorted, the field format is of type char, but the stored value is a number. Now you need to sort the field.

Find the following two ways to record them.

1, you can convert to int type reorder

Select *  from Jzd  orderbyconvert(intdesc

But this method is not good in access because there is no convert function.

So the final use of the 2nd clock method

2, you can be in front of 0, and then intercept the same length and reorder

Select *  from Jzd Order  by  Right ('+'+ID,4desc

Use this method to solve the problem.

Sorting SQL char field types