Given a flat-file:
1###A###703 2###D###203 3###E###303 4###J###901
The file is sorted by field2.
In SQL it is irrelevant what order the physical file is sorted in. If you want a list sorted by field2, you just use the SQL clause "ORDER BY field2" when you do a SELECT and it will be returned to you in that order regardless of the order of the physical file.
This question has to do with SQL, not with DBI. You'd be better off looking for SQL answers someplace devoted to SQL. Try a google for "SQL Tutorial".
-- Jeff
