>>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 :-)

I think it should be either O - outstanding or A++