Simple conversion (I thought) 1

[Newbi1]

CR 9 --SQL Server -- Win XP

I have a numeric field which I was trying to concatenate with a string field for formating purposes.

an intial value would have been 200000

{tfacr200.tdoc} + "  " +  Replace (cstr({@docn}),"," ,"" )

When I do a Cstr({value}) I now get the headache of 200,000.00. I can do a replace to get rid of the commas, but how do I get rid of the decimal and added 0s?

I thought it was a simple formula, but with the added junk, not sure if I am doing it right.

 

[vidru]

If you're certain you don't need the decimals, you can use the ToText function like this:

{tfacr200.tdoc} + " " + ToText({@docn}, 0, "")

... where 0 represents the # of decimal places, and "" is the Thousands separator.

-dave

 

[KerryC]

Check your number format under Regional and Language Options on the Control Panel. It's likely let to 2 decimal places. I've run into this before and it's a pain.

Kerry