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

>
>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 ?

i want use only PERC<=100