Is there a way to update a table so that a column's values can be changed to a concatenation of two other column values? For instance, something like ...

UPDATE TABLE tablename SET colA = colB.colC;