convert varchar to int in select query order by

  • Home
  • Blog
  • convert varchar to int in select query order by
About

convert varchar to int in select query order by

March 21, 2020 in MySql, Tips and Tricks

Sql Server query varchar data sort like int

MySQL ABS() returns the absolute value of a number.

SELECT * FROM MyTable ORDER BY ABS(MyCol) DESC;

aditya singh

Leave a Reply