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?
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
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...