Would this worked?

UPDATE dbo.myTable SET column1=MyFunction(column1),@myValue=MyFunction(column1) WHERE selectTheRow

UserDefine function
---------
MyFunction(@Number)
return @Number + 1

Just an example, maybe sintax is not correct