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