Swapping (replacing) values in one column with another column.
Posted on 2003-03-25
I have the following 2 issues in regards to replacing values in columns.
I would like to swap the values between columns for all rows in Table A. That is, Column 2 data is moved to Column 1 and Column 1 data is moved to Column 2.
- Column 1
- Column 2
I would need the value for Column 1 moved to Column 2 and Column 1 replaced with the Column 1 value from Table A above after it's data has been adjusted. It will need to match the value from Table B Column 2 with Table A Column 2 (after Table B's Column values have been adjusted). When a match is found the Column 1 value from Table A would be inserted into Column 1 in Table B.