Hi Jim,

I think Bob mentioned this already but I would like to stress it one more time. T-SQl SELECT is much more powerfull than in VFP. You can replace a big chunks of your code with one T-SQL select but it requires different thinking.

Good luck.

>Thanks Sergey. That makes it clear.
>
>I'm now heading back to my "Inside SQL Server 7" book for a refresher on all this stuff.