>Any idea how to write the following code in shorter form:
>
>

update tallamat set c30='34' where c30='3'
>update tallamat set c30='35' where c30='3½'
>update tallamat set c30='36' where c30='4'

I agree with Larry that you should put the values in a cursor or table. But you don't a loop after that. Use UPDATE or REPLACE together with the LOOKUP() function to do it in one statement.

Tamar