Copies the current table to a new table, arranging records in
the specified order.   ON <field 1> [/A | /D [/C]]   [,<field 2>
[/A | /D [/C]]...] [FOR <condition 1>] [WHILE <condition 2>]
The new table file to copy and sort the current table's records
to.   Specifies the type of table you want to create, if
<filename> does not include an extension. This option overrides
the current SET DBTYPE setting. The TYPE keyword is included for
readability only; it has no effect on the operation of the
command.  ON <field 1>  Makes <field 1> the first field of
<filename>and sorts <filename> records by the values in <field
1>, which can be any data type except binary, memo, or OLE.
Sorts records in ascending order (A to Z; 1 to 9; past to future
(blank dates come after non-blank dates); false then true).
Since this is the default sort order, include /A for readability
only.   Sorts records in descending order.   Removes the
distinction between uppercase and lowercase letters. When you
specify both A and C, or both D