i want to write an update statement that has numbers, its a varchar datatype. I want to replace each occurrence of a number with different number. For ex. 0 will be replaced by 1, 1 will be replaced by 5 , 2 will be replaed by 7 and so on.
So if a row with value of 012, should be updated to 157.
Can someone help me write an update for this, it has to be an efficient update statement as i have a large number of rows to be updated.

