No, this query will not run in VFP8 or any other ANSI compatable backend. The query doesn't specify from each record of the group Fundvalue value comes from. It's coinsedence that in VFP it comes from the last physical record in a group.
>
>Thanks for your code, it works fine. I was playing/testing around myself in VFP 6 and I found that just grouping the special also works, I only don't know this is pure luck or wisdom:
>
>
>select *;
>from MyTable;
>group by special;
>into cursor crsResults
>
>
--sb--