Erudite indeed, but I don't think this is ever going to matter to me.

The solution seems a bit opaque. Something like this is (to me) much more straightforward for the next person who has to read it:

update #t

set col1 = case col1 when...