Earlgray Earlgray - 2 years ago 85
SQL Question

How to multiply value in table column?

I have to edit table in my database. I have column

[Width]
and I have to multiply this
[Width] * 10
for all rows. How can I do it?

Answer Source
UPDATE TABLE
SET WIDTH = WIDTH * 10
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download