DECIMAL TO STRING

deesh · Post by **deesh** » Sun May 17, 2009 3:21 am

Hi Friends

When I have generating the values from DECIMAL TO STRING Its not giving the exact rsults Can some one help me.

condition:

DecimaltoString(column name)

results :: 09400077.
09400259.
09400417.
09400634. at the end giving dot( . ) I dont need that dot and moreover the decimal size is 8 and string size is 16 .

ray.wurlod · Post by **ray.wurlod** » Sun May 17, 2009 3:30 am

The dot is correct. This indicates that it's a decimal. If you don't want the dot, explicitly trim it off. What do you want to do with the additional eight character positions? Whatever it is, you have to specify it.

chulett · Post by **chulett** » Sun May 17, 2009 8:52 am

Sounds like you don't actually have decimal values you're working with.