No, didn't test in VFP (don't have it installed locally). I guess it's too bad and it is not going to work in VFP.

>Naomi,
>
>did you test the statement? I get error "Invalid use of subquery"
>
>with :
>

>select  score , team ;
>	from crResult as A1 ;
>	where (select count(*) from crResult as A2 where A2.team=A1.team and A2.score<=A1.score ) <=2 ; 
>	order by score
>

>Regards,
>
>Koen
>
>P.S. My testdata consists of CREATE CURSOR crResult (team c(4), score n(2,0)) with values as per example given