>>> >>>sele res >>>SET ORDER TO CODE >>>GO TOP >>>DO WHILE .NOT. EOF() >>>IF PERC>=80 .AND. PERC<=100 >>> REPL GRADE WITH "A+" >>>ENDIF >>>IF PERC>=70 .AND. PERC<79.99 >>> REPL GRADE WITH "A" >>>ENDIF >>>............. >>>>>
>>update Res SET Grade = ICASE(BETWEEN(Perc, 80,100), 'A+', Perc >= 70, 'A',...)>>