Alter Column Formula.

hi,

alter table dbo.MyTableName
  drop myColumnName

alter table dbo.MyTableName
  add myColumnName as (CONVERT([decimal](15,2),[Casting Internal Sales - Casting Unit Price]*(0.7),(0)))

http://technet.microsoft.com/en-us/library/aa275462(SQL.80).aspx

HTH
  David

PS Computed columns are great, but having to change the column definition frequently isn't that great. Are the other ways you could do this wihtout a computed column? Or is this change a one-off?

PS Cant alter computed columns

>>
The altered column cannot be:
A computed column or used in a computed column.
<<

I did as you said but I got this error:

Msg 3728, Level 16, State 1, Line 1
'Inventory Envaluation - As Cast' is not a constraint.
Msg 3727, Level 16, State 0, Line 1
Could not drop constraint. See previous errors.

And this is my codes:

alter table Main
  drop [Inventory Envaluation - As Cast]
alter table Main
  add [Inventory Envaluation - As Cast] as (CONVERT([decimal](15,2),[Casting Internal Sales - Casting Unit Price]*(0.7),(0)))