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
Post a Comment