SQL select statement question. Dive all numbers in a column.

Question

How do I replace all numbers in a column of a table to divide my 0.6. Let's say the column reads:

1
2
3

I want it to become:

0.6
1.2
1.8

Answer 1

Go to the SQL view and type:

select columnname*0.6 from tablename

Replace columnname and table with your table/column names. By the way, that's multiplying by 0.6, not dividing.

Answer 2

UPDATE mytable
   SET mycolumn = mycolumn * 0.6;