I have a new problem now

It seems the conditions in the update statement are susceptible to change.

So, I was thinking about having all the case statements in a table

something...

Thanks all for your replies

They were extremely useful

Thanks for your reply.

The problem with having separate update statements for range and some_value is that certain update statements use both the columns.

E.g. update large_table

set field1 = 4.00

where range >...