Updating column

[cyborg]

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

[bamcorp]

update test
set column_2 = 'A' + column_1

[cyborg]

Here the solution:

Update TABLENAME set COLUMN_1 = 'A' || COLUMN_2


Thanks

Cy