>>Justok,
>>There is something wrong here. Group by takes the last entry.
>>Cetin
>
>

---

>
>Oh.. Then it is finished.. :))
>
>Well, In case to take the first occur value from natural order, would you tell me how to code?
>(This learn is for interest only, not my boss request.)
>
>Thankyou.

I had to do this once. What I did was:

select * from originaltable into cursor othercursor order by MyDesiredOrder

and then I can do the «group by select» from the OtherCursor because it is already naturally ordered the way it needs to be.