USE JRandomTable
SORT TO SomeOtherRandomTable ;
ON SomeNumFld /A, ;
SomeChrFld /D, ;
AnotherChr /AC
This would create a table SomeOtherRandomTable.DBF containing all the fields in JRandomTable, sorted first by SomeNumFld in Ascending order, within any set of records that have the same value for SomeNumFld, the subset of records are sorted by SomeChrFld in Descending order, and then within any group have the samevalue for both SomeNumFld and SomeChrFld, the subset is sorted by AnotherChr in Ascending order in a case-insensitive manner. Example data:
1,"Foo","Bar"
7,"Mumble","Bletch"
1,"FOO","banana"
1,"FOO","BAR"
1,"Mumble","Grr"
would sort as:
1,"Mumble","Grr"
1,"Foo","Bar"
1,"FOO","banana"
1,"FOO","BAR"
7,"Mumble","Bletch"EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater
NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC
The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys