SQL ORDER chars numerically -


I have a column of numbers stored in the form of letters when I make an order for this column then I get the following Is:

100
131
200
21


31000
etc.

How can I order these characters numerically? Do I need to change something or is there already a SQL command or function for this?

Try it:

  Cast Order by (column as integer)  

Comments