Help in varchar column calculation
Hi, How I can calculate and get the calculation result of calc4 colum. Currently this is varchar but i want to calculate calc1+calc2+calc3 in calc4.
Create table Calculation (Calc1 numeric (10,2), calc2 numeric (10,2), Calc3 numeric (10,2), Calc4 varchar(40))
insert into Calculation (6,7,8, ‘calc1+calc2+calc3’)
Desired result want:
Select * from Calculation
Calc1 calc2 Calc3 Calc4
6 7 8 22
Hi, How I can calculate and get the calculation result of calc4 colum. Currently this is varchar but i want to calculate calc1+calc2+calc3 in calc4. Create table Calculation (Calc1 numeric (10,2), calc2 numeric (10,2), Calc3 numeric (10,2), Calc4 varchar(40))insert into Calculation (6,7,8, ‘calc1+calc2+calc3’) Desired result want:Select * from CalculationCalc1 calc2 Calc3 Calc46 7 8 22 Read More