>>>

>>>UPDATE res SET grade = ICASE(perc>=80, "A+", perc>=70, "A",...)
>>>

>>>
>>>>can you give more help
>>thanks Sergey
>
>If table is big REPLACE ALL may be faster
>

>REPLACE ALL grade WITH ICASE(perc>=80, "A+", perc>=70, "A",...)
>

Replace ALL places a lock on the table. We used SCAN replace ENDSCAN because of that problem.