I have a table with a name (varchar) field that only holds numeric string and I want to order my queries by this field. But name fields are being ordered by alphabetically but I want them to be ordered numerically. For instance if I get 1 2 200 100 as name fields values, It is being ordered like 1 100 2 200 but I need them to be 1 2 100 200.I have a table with a name (varchar) field that