>>

>>select * from myCurs1 c1 ;
>>  where end_time = ;
>>  (select max(end_time) from myCurs1 c2 where c1.room == c2.room)
>>

>
>Cetin,
>
>Are you sure that the above could be applied to VFP 8? I am getting syntax error on the SQL Select so I thought maybe the code above is only applicaple to VFP 9.
>
>UPDATE: My mistake. Sorry.

FYI Above code is fox2x and up compatible.
Cetin