>>Can these codes change into sql.
>>

>>
>>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.9
>

>
>But, there is a way to do it in one command. Maybe someone else will contribute.
thanks Michel