In ASP, using ADO, you sort a set of records using the Sort property.
objMembersRS.Sort = "FirstName"
In Paradox, you add an index for each sort your wish to perform on a table then use switchIndex(). Alternatively, you can use sortTo() to sort a table into a new table.