problem with a decimal field

vij · Post by **vij** » Mon Jan 08, 2007 10:29 pm

Hi,

I have a string field column, which is to be converted into decimal when it is loaded into the xml.

Now the problem is- the input string is "00000499" and after i convert that to decimal(7,2), it is loaded with zeros infront of the decimal.

pls tell me how to remove the leading zeros?

Thanks

ray.wurlod · Post by **ray.wurlod** » Mon Jan 08, 2007 11:52 pm

Decimal data types are displayed with leading and trailing zeroes so that you can be sure that the precision and scale are handled correctly.

The only way to lose them in a parallel job, without using BASIC components, is to convert to string and trim the leading zeroes (and trailing zeroes if desired).

vij · Post by **vij** » Mon Jan 08, 2007 11:56 pm

Hi Ray,

sorry to say this - i am not able to read ur message completely, as i dont hold the premium membership. can u pls post the reply visible to me? pls

ray.wurlod · Post by **ray.wurlod** » Tue Jan 09, 2007 12:02 am

vij

Premium membership is used to help pay for the bandwidth needed for this site to continue to operate. It does not cover the entire cost, because the owners of the site have elected to keep it affordable (only a few cents per day) - most people think you get good value for money.

Therefore, I will encourage you to purchase a premium membership, rather than undermine one of the site's funding sources.

Oh, and do find yourself some pronouns!