SQL Server converts the varchar type to the int type before sorting

In SQL, convert the varchar type to the int type and then sort it. If the database ID is set to the orderbyid OF THE varchar type during query

In SQL, convert the varchar type to the int type and then sort it. If the database ID is set to the order by id of the varchar type during query

If the database ID is set to the order by id of the varchar type during query, we do not want to see the following situation.

We can convert varchar to int and then sort it.

I,
The Code is as follows:
Select * from yourtable order by cast (yourcol as int );

Applicable to SQL Server Oracle

II,
The Code is as follows:
Select * from yourtable order by convert (int, yourcol );

Only applicable to SQLServer

Author: itmyhome