For those of you who might need some kind of help regarding this issue in the future, here is the solution we managed to figure out:

UPDATE tbl1

SETaccountNumber = '3' +...