Database query character format variables sorted by integral type __ Database

In the database design, in order to save the processing convenient, many cases will be the number of format fields as a string format inserted, but in the query, if you want to follow this field to sort the words will have a small problem. The database is processed in the order of the string, as shown by the ordering by sort:

This problem occurs when the item field is varchar in the type of the database, but the ordinal of the integer is stored.

The solution is very simple, that is, when the query to the field in the cast method format to type int, and then sorted, the result is as shown in the figure: