> >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 >............. >You can do it in two SQLs such as:
UPDATE Res SET Grad="A+" WHERE Perc>=80 AND Perc<=100 UPDATE Res SET Grad="A" WHERE Perc>=70 AND Perc<=79.9But, there is a way to do it in one command. Maybe someone else will contribute.