Updating a table with a function in SQL

Question

Say I want to take average of a set of numbers I have in a table and want to put that average in another column in the same table. How would I do that?

Help is much appreciated

Answer 1

UPDATE [tblname]
SET [columnname] = ([h]-[hr])/([ab]-[k]-[hr])

Answer 2

Try....

UPDATE hitters SET ColumnName = (((h-hr)/(ab-k-hr))