>Ok, if you send me the code I will appreciate so much.
>
>thanks in andanvace
>
>CB


Here is VFP idea, needs to be adjusted for SQL Server:

select my.* from myTable my ;
inner join ;
(select ctobin(right(max(dtos(date)+bintoc(ID)),4) as ID, MyGroupField ;
from myTable group by myGroupField) MaxInfo on my.ID = MaxInfo.ID

From http://forum.foxclub.ru/read.php?32,177183,177232#msg-177232 (in Russian)