>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.
>>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 >>>>