>> >>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 Grad="A+" WHERE Perc>=80 AND Perc<=100 >UPDATE Res SET Grad="A" WHERE Perc>=70 AND Perc<=79.9 >>