WriteLn(@Str(@Int(MoneyField)))

I am trying to do what I imagine is a very very simple thing to most...
I need to remove the decimal and trailing zeroes from money fields while allowing the money element to remain as money...
I have tried playing with numerous iterations of the following and can delete stuff to the left of the decimal and to the right of the dollar sign with no problem (figuratively at this point of course) but...
I really need to be rid of the decimal and trailing zeroes...
When I use WriteLn I can "echo" the fact that I have "n" characters and this "n" value always corresponds to the the dollar amounts sans decimal point and zeroes...
My "code" in its current useless iteration follows...

Var vbucks as double
var buckslength as int

vbucks = sr_max_lim
buckslength = @Len(vbucks)

sr_max_lim = @left(@str(vbucks),2)

As always...any and all help is very much appreciated...

Thank you ...

Cliff

Sorry about cluttering up the forum with a similar post...wasn't quite sure how to "reopen" a solved issue...

The fix you previously gave me creates a pop up that shows the number of characters left of the decimal, in other words I'd see the number "4" pop up for example if $1,234.00 were in the sr_max_lim field.

The fix seems to point in the right direction (echoing the digits to the left of the decimal) so I tried working with that code to see if I could accomplish the stuff I describe below but...alas...I have thumbs for code..(or something like that)...

We are developing a database for the issuance of insurance policies automating an existing manual process with Sesame.
Part of what we want the database to do is produce what are known as declaration pages. These "dec-pages" define policy parameters for insurance agents and include policy premium information.

Historically, the manual process did not include the "cents" portion of money values as all dollars are rounded off to the nearest hundred. In keeping with precedence we want to do the same thing with Sesame.

That said, what I am trying to do is modify the money elements in this database so we see only $1,234 in the database with the intent that the same will then print into our merge docs (we are using WordMergeLite).

I can do this easily enough by changing the fields to numbers but...the caveat there is that we lose the commas...and, of course...we must have commas...!

Interesting world this IT biz...

I do very much appreciate your help...
Thank you kindly...
Cliff

Hi Hammer...I am here two days a week only so have not responded sooner.
I've changed all the "money" fields to "number" fields, however...no commas...when posting to WMLite...