You can use SELECT statement to do that.
>I am trying to physically reorder the table by ID number starting with 1 as the first ID number at the top of the file. It would make it easier to browse the table and find certain entries from the command window that way. Perhaps there is a SORT command I can use. I will check into that. Right now my table show ranges of ID numbers when I browse such as -
>4001
>4002
>4003
>5001
>5002
>5003
>1001
>1002
>1003
>1004
>1005
>6001
>6002
>3001
>3002
>
>I would prefer to see them in sequence when I browse the table. HTH
--sb--