> >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 >............. >Try UPDATE-SQL command
update Res SET Grade = ICASE(BETWEEN(Perc, 80,100), 'A+', Perc >= 70, 'A',...)What do you want for the case when Perc > 100 ?