>In VFP, CURSORS created using SQLCONNECT for C/S applications can be sorted dynamically. You can create INDEX for use to dynamically sort the displayed data without re-executing the SQLCONNECT. How about in VB? How would we be able to change the sort of a recordset dynamically?

ADO recordsets can be sorted without going to the server. See the Sort method of the ADO recordset object.