dbonneau Starting Member
42 Posts
sunitabeck Flowing Fount of Yak Knowledge
5152 Posts
update my_table set Total_field = ( cast(Field_A as float) - cast(Field_B as float)) from my_table;
quote:Originally posted by sunitabeckYou will need to cast field_a and field_b to a numeric type if they are of character type - for exampleupdate my_table set Total_field = ( cast(Field_A as float) - cast(Field_B as float)) from my_table;
madhivanan Premature Yak Congratulator
India 22461 Posts
operand data type nvarchar is invalid error
Posted - 11/11/2012 : 05:07:47
