hi,
thank you for reply,
I a gree 100%
thank you again.

m.qasem
>Mohammed,
>
>Both, SCAN and REPLACE have FOR clause where you can specify a filter

>USE table1 IN  0
>SCAN FOR plan > "00:00:00"
>...
>or
>replace plan1 WITH VAL(SUBSTR(plan,1,2))*60+VAL(SUBSTR(plan,4,2)) ;
>   FOR plan > "00:00:00"
>

REPLACE with FOR clause will be faster because it loock the table once for the duration of operation. That's also its downside.
>
>
>>it works as
>>

>>USE table1 IN  0
>>  SET FILTER TO plan>"00:00:00"
>>SCAN
>>replace plan1 WITH VAL(SUBSTR(plan,1,2))*60+VAL(SUBSTR(plan,4,2))
>>ENDSCAN
>>

>>