Insert the same column data to another column of the same table 2

[cesark]

Hi there,

How can I insert in a column of a table the same data that another column has?

For example: From 'Orders' table, update 'telephone_contact' column with data from 'telephone' column.

Thanks

 

[SQLDenis]

update orders
set telephone_contact = telephone

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[amrita418]

Try this:

update   Orders
set      telephone_contact = telephone

Best Regards,
AA

 

[cesark]

Ok, that' s fine!

Thanks