>>It does not appear that ADS supports this query.
>>I am thinking about reading the ADS table into .NET and doing the processing in .NET instead.
>
>What do you mean here? And how .NET is going to help?

I suppose I should have known better than to mention .NET in the VFP forum :)

Any full featured programming language will work here, it doesn't have to be .NET (it could be VFP).
I would just do all the processing in several steps locally instead of on a database server.