Hi Chad,

>>Check table.Select method.
>
>I did. That only allows a filtering of the rows if I RTM correctly. I need to run more complex SQL statements on it.

Yep, you're out of luck. You'll either find a way to do all on the SQL server (I think there is a way to pass an ADO.NET object to a SQL server, but it aint pretty, or write an algorithm to do it on the ADO.NET record set mannually.

This is one of the areas where VFP shines and I've always critisized .NET for. .NET's LINQ project is taking an effort to make this easier on the .NET platform, but it still is 2+ years away from release.

Walter,