Swap fields in a table

[artmaat]

I need to switch the info in two fields basically reverse the info. I have several hundred records to deal with. This needs to be done only when a third field is <null>
So its like this:
1) Switch COSTCODE and EQUIPMENT when EMPLOYEE is <NULL>
2) Then when EMPLOYEE is <NULL> change to '52001'
Can someone help me with the SQL statement to do this.

 

[bperry]

This sounds straight-forward.
Two separate update statements.

Update MyTable SET
CostCode = Equipment,
Equipment = CostCode
Where EMPLOYEE IS NULL

Update MyTable
Set EMPLOYEE = '52001'
Where EMPLOYEE IS NULL

Should work fine, but as always, test before using on live data.

bperry