>>

>>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",...)