Methods for converting varchar types to int type in SQL Server

In SQL, the varchar type is converted to int and then sorted, if our database ID is set to varchar type, the order by ID when queried.

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

We can convert varchar to int and then sort

One

Copy CodeThe code is as follows:
SELECT * from Yourtable order by cast (yourcol as int);
For SQL Server Oracle

Two
Copy CodeThe code is as follows:
SELECT * from Yourtable ORDER by convert (Int,yourcol);
Applies to SQL Server only

Server: SQL Server 2005

Implementation function: The conversion of int to varchar type, the field of type int is 8 bits

Implementation process:

Set the field of int to Aa,varchar field BB

Update table name

Set Bb=cast (AA as varchar (8))

Then execute, execute successfully

Methods for converting varchar types to int type in SQL Server