How to get rid of zeros in the output

Hope · Post by **Hope** » Tue Sep 04, 2007 8:10 am

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

ray.wurlod · Post by **ray.wurlod** » Tue Sep 04, 2007 4:21 pm

You will find your answer by searching in the correct forum. Do an "all terms" search for View Data decimal