is it possible to sort a recordset after opening it from the db? i'm pulling data through an sql statement and know i can just use ORDER BY but i'm selecting distinct records and have to sort on a field I am not selecting. when you try to do this using distinct, it will not let you. so an ideal way for me to do it is to sort after i pull the data out. any ideas? thanks!