Sorting After SQL Select Statement

[Guest_imported]

I'm using a regular expression to count the number if times a particular word appears in a selected record, I now need to sort those selected records in order by the number of counted words found in the record. I've gotten to the point of having a list of records and the 'keyword' word count for each record. What I can't figure out now is how to sort them in, say descending, order.

Any advice? Let me know if you need to see my code.

Thanks.

 

[Mighty]

I'm not sure exaclty how you are determining the number of keywords. But what about storing the recordset in an array using the GetRows method and then using a sort function to sort the array. if you are sorting based on numerical data, it will be easy to write the sort function to use with the array sort method. Mighty