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
Printable View
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
update test
set column_2 = 'A' + column_1
Here the solution:
Update TABLENAME set COLUMN_1 = 'A' || COLUMN_2
Thanks
Cy