Gerard,

How about...

SELECT MAX(Fld1),
MAX(Fld2)
FROM MyFile
GROUP BY Fld1
INTO CURSOR Temp

Hope this helps,



Gerard wrote -

I have a file as follows:

Fld1 Fld2
_____________________________
AA Widgets
AA
AA
AA
BB Spark Plugs
BB
BB
CC
CC Emeralds
DD


______________________________

I want to do following
Select * from MyFile Group by Fld1 into Cursor temp

.. but I want to ensure that I always get the description, if there is one in the result i.e. I need the following:
(I will only have spaces or the same value)

AA Widgets
BB Spark Plugs
CC Emeralds

I'm wondering is there a SQL way of doing this, or maybe some other way ?

Regards,

Gerard