Table Numeric Sort Order

I am needing to sort a table in numeric order (i.e 1,2,3,4,10,12,14 etc.) but it appears to be sorting my the first numeral only (1,10,12,14,2,3,4).

Unfortunately these values are stored as strings (Varchar) instead of a number or decimal. I’ve tried using .toNumber but this didn’t make any difference.

Community Page
Last updated: