Hi
I need to find a way to duplicate a whole column within a table so the new col has a different name but the contents are copied line by line from the old column to act as a temporary reference
I could just create the new col manually but how would i say "copy the contents of col1 into col2" for each line ?
I can't find a thread that mentions doing this
thanks for any help you can give