I have to calculate the sum of rows in a particular column. The input column datatype is decimal.I have given the output column length as decimal(15,2).When I look at the output zeros are padded.Ex: if the sum is 879897.79 .The output is 000000000879897.79
1.how I can get of rid of zeros before the number.
Please help
How to get rid of zeros in the output
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: