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

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