Question: how to copy data from one field to another in sql?
Answer: Open the table with columns you want to copy and the one you want to copy into by right-clicking the tables, and then clicking Design.
Click the tab for the table with the columns you want to copy and select those columns.
From the Edit menu, click Copy.