>>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++
If it's not broken, fix it until it is.
My Blog