Philip,
Thanks for your reply.
I have not used the Max function before, but if it works on Character fields, it sounds as if its just waht I need.
Regards,
Gerard
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only