Hello, I have a table with 3 fields - the unique identifier, name and rank. I have 500 records so far in the table.
I want to make a 4th field called rank2. Is it possible to copy all the data in the rank field over to the rank2 field in one command?
Thanks