Copy data to different field, same table 1

[MagicGirl]

Hello, I have a situation where I would like to copy or move data from one field to another on the same table (same data type). I am having trouble with the info from the sources I am using; "Teach Yourself SQL" will only go so far! I have located a wealth of information on this forum on moving data from table to table, but have yet to find something specifically referencing a within-table copy or move. This is a one-time process to correct an error, not something which needs to be automated during data entry. Any help would be extremely appreciated! Thanks!

 

[sunila7]

Hi,

Try this...

UPDATE TBL SET NewFldname = OldFldName

Hope this is what u r looking for...

Sunil

 

[MagicGirl]

Thanks for your quick reply, Sunil! - before I try it, will this copy the data, or move the data?

Susan

 

[sunila7]

Hi,

It will update the new column name u want to update from the old column name, so basically both the fields will have same values after u execute the above statement....



Sunil

 

[MagicGirl]

Hi, Sunila,

Thanks again - this worked perfectly!

Susan