>Hi All:
>
>I have a table where there are dupes in a particular column, FOO. I want to create a cursor that will contain only one record per FOO, so I coded:
>
>

>SELECT * ;
>FROM ImpHeader ;
>ORDER BY FOO ;
>GROUP BY FOO ;
>INTO CURSOR curHeader READWRITE
>

>
>VFP doesn't like the GROUP BY, but it is a pain to GROUP BY all the other fields or aggregate them. I do need the data from the other fields, so SELECT DISTINCT FOO would not help.
>
>What is the solution?
>
>Thanks,
>
>Yossi

select * from ImpHeader I1 where PK IN (select Min(PK) from ImpHeader i2 GROUP BY Foo WHERE i2.Foo = I1.Foo)

Actually, you don't even need to make this query to be correlated, and this version will also work as long as you have a primary key:

select * from ImpHeader I1 where PK IN (select Min(PK) from ImpHeader i2 GROUP BY Foo)