>>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 :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.