Forum Discussion
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)...
Hi,
Desired result :
Select * from Calculation
Calc1 calc2 Calc3 Calc4
6 7 8 22
9 9 9 27
Desired result :
Select * from Calculation
Calc1 calc2 Calc3 Calc4
6 7 8 22
9 9 9 27
SmithToronto , as I wrote, error-prone.
You can use a cursor to loop through all records.
- Hi olafhelper, Can you please help on this SQL? Thanks