Example:

Tablename: Test
Columns: Column_1, Column_2

Column_1 Column_2
101 101
102 102

Column_2 should become A101, A102 ...

Result:

Column_1 Column_2
101 A101
102 A102


update test set column_2 ??????

Thanks

Cy