How do I move data from one column to another? (1 Viewer)

[davidg47]

If I want to move all of the data from Column A to Column B, deleting the data from Column A, and making sure the data stays with the same row, how do I do that?

Would it be something like:

update tablename
set [dateB]=[dateA];

del [dateA];

I am only guessing here...

Thanks,
David

 

[FoFa]

Your update is basically good, but don't use delete, use another update instead.
Update tablename
SET [dateA] = NULL

 

[Brian1960]

Sql

HI,
Not a bad attempt.

Update tblName set fieldA = fieldB;
Update tblName set fieldB = null;

Hope this helps,
B

 

[davidg47]

perfect... thanks guys. I'll let you know how it goes.

 

[davidg47]

Works perfect... thanks for your help.