Copy column of data into another column in the same table

I have a column of digits I'd like to copy into another column in the
same table. How would I do this?

Thanks,

BillOn 18 Jul 2003 11:06:33 -0700 in comp.databases.ms-sqlserver,
billzimmerman@.gospellight.com (Bill) wrote:

>I have a column of digits I'd like to copy into another column in the
>same table. How would I do this?

update table set column1 = column2
--
Ride Free (but you still have to pay for the petrol)

(replace sithlord with trevor for email)

Converting of Decimal digits to string

Hi .,
I am facing a problem in converting a number with a maximum decimal digit
of Six to a Comma Separated String.
For Ex.
if the number is 123456.36987 , my expected result is 123,456.36987
if the number is 123456789.36 , my expected result is 123,456,789.36
Please give valuable suggestion...
With Regards,
R.RamaKrishnanGo here:
http://msdn.microsoft.com/library/d...br />
2f3o.asp
...and look for "style values for float or real".
ML
http://milambda.blogspot.com/|||Hello,
If you do not need more than 4 decimal places, you can use the
conversion style 1 for a money value. See:
http://msdn.microsoft.com/library/e..._ca-co_2f3o.asp
However, this is usually handled in the front-end and it's probably
easier to specify a format in the application, not on the server-side.
Razvan