DSXchange

The leading zeroes are an artifact of the data viewer. They are not really there when a decimal data type is stored. Ignore them - they are included to prove that the precision and scale are being a ... Thanks Ray, I could not able to read your reply since was under "premium contents". ho...

Hi, Use numeric function to round the value. Else convert into char and send it Regards, -- sudhakar Thanks Sudhakar, Basically I have another requirement, the decimal places in the amount field has to be dynamically set based on the currancy we are using for that row, so I have written small C pro...

Hi everyone, I have some strange requirements. I have several amount fields with the data type Decimal(26,3), While extracting into the file I have to produce data like: 1. empty value if the data value is 0.00 2. non-padded zero data with, currently it produce values padded with zero e.g. Data is =...