DSXchange

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 .

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.

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