How do you copy one field to another? 1

[meeble3]

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

 

[johnwm]

Update table2 Set `rank2` = `rank`

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller