>Michael,
>
>Here's a shot in the dark, but Fox sometimes had problems with ;'s if there was no space between it and the end of the line it continued. This was fixed in VFP, so I doubt it is it but it only takes a second to try. Just insert a space before each ; so you have;
>
>SELECT Blah, Blah, Blah ;
> FROM Blah, Blah ;
> ...

WOW! That was a tough one! After whittling it down, turns out that my problem was in placing the ORDER BY before the GROUP BY statement! The order of these two didn't create a problem in VFP3.0, but choked VFP6 big time (I haven't tried it in VFP5)!

Looks like they plugged the hole.

I thought I'd post the problem - not that too many people would stumble on this particular problem, but perhaps just knowing that SQL Syntax has become stricter may help someone else out of a jam.

Thanks, Jim!