[Resolved] Dulpicating a column

[bobcox]

I need to duplicate a field (column) in a table so that I can use the current data in the filed but rename the duplicate and use it for a differnet purpose.

Can anyone help with the query to copy column and data to a new column please?

Bob

[leatherback]

i think...

query: update table set field_new = field_old

J.

[bobcox]

leatherback

You're a star

The query is spot on

Thanks

Bob