I have a column of numbers stored as chars. When I do a ORDER BY for this column I get the following:
How can I order these chars numerically? Do I need to convert something or is there already an SQL command or function for this?
ORDER BY CAST(thecolumn AS int)