DSXchange

I have a Decimal(11,2) that I want to add to a Sequential file in a Varchar field. For instance, I want to see "Total: 9999.99" in the Sequential file.

I'm finding that it's not always showing the 2 decimal places.

So I went searching for a way to force it to always show 2. I've seen discussions on DecimalToDecimal and DecimalToString, but I didn't get anywhere with those.

I finally stumbled upon Fmt(number, 'R2') which seems to be doing the trick. This seems so easy, so I'm wondering why this hasn't been in any of the posts I've seen here regarding showing the decimals. Is there something wrong with this?

No, nothing wrong with it and it's out there in posts. DecimalToString() should have worked as well AFAIK, what syntax did you try?

DecimalToString is a parallel function isn't it?

Why, yes it is. Since the question was about contrasting the two approaches, I kind of ignored the Server job type / posted forum part. Perhaps that explains the "didn't get anywhere" comment.

Thanks!

Since I got the "nothing wrong with it" response I was looking for, I'll follow your lead and ignore the rest of this so I don't waste anymore of your time.

chulett wrote:Why, yes it is. Since the question was about contrasting the two approaches, I kind of ignored the Server job type / posted forum part. Perhaps that explains the "didn't get anywhere" comment.

I have a tendency to ignore that section too, just doesn't seem to stand out for me...