SQL string data is sorted by int type, stringint

SQL string data is sorted by int type, stringint

Note:

I found a problem during wms invoicing: A warehouse receiving ticket (T_OutIn_BoxTop), which should be divided into multiple boxes during warehouse scanning. The box number (BoxTop_No) can be either a number or a string, so the box number can only be of the string type. The question is, how can we sort it?

The details are as follows:

Sorting:CAST (Box_No as int)

SQL statement:

SELECT * FROM T_OutIn_BoxTop

WHERE MainTop_ID = 17722Order by cast (Box_No as int) ASC