Nadya,
> Yep, of course.
Just checking the obvious *g*
>>It also looks like this might be a "data" problem. Are you sure that all rows have a valid value in extryear?
>
> I checked it on Friday (brow for empty(extryear) - 0 records). I'll check again, probably. But in this case SQL woudn't work in VFP6.0 also, right? But it works...
How about
select extryear, count(*) .. group by 1
Check for NULLs and other types of corrupt data.
The only reason it doesn't work in VFP5 was because of the SET TALK differences as far as throwing an error are concerned.