>>>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 ?
>
>
>
>:-)))))))))))
>You already have it. It is "A" :-))))
>Just because 100.01 is bigger than 70 :-)
what is your mean Boris:please explain me more.