How do I get the database tables in alphabetical order using numbers?

Question

Some begin with numbers and some with letters. I want to sort them. How?

Answer 1

you could use a program to access your tables, read the content into an array of objects sort the array, delete the table and write all the array content back to the table. Then the table is sorted. I agree with the previous answer: information you provided are not sufficient.

Answer 2

Your question is a little unclear and I can only give you a really basic answer. You have to choose one of the fields in the database and say something like (depending on which database you are working with):



select * from ..table.. order by ...whatever..



You can reverse it with a decend command, dec;:



select * from ..table.. order by ...whatever..desc;

Answer 3

numbers are not part of the alphabet, so you cannot organize letters alphabetically. you can sort them numerically. most systems list numbers numerically before letters, some list them after.



but if you use the sort by command in asc or desc it will list your returns alphabetically.