>Hello,
>
>I try to replace a numeric field with str() but not work,
>
>account_am = 1948.00 to have accountchr = 1948 without .00 after and does not
>any space after too.
>
>means only 1948 in accountchr nothing more.
>
>with
>
>REPLACE accountchr WITH STR(account_am,16,0)
>
>Any help would be appreciated
>
>TIA

It depends on the data type "accountchr" is. If it's a numeric (4, 0), then simply

REPLACE accountchr WITH INT(account_am)

should work.

If it's c(4) then

REPLACE accountchr WITH TRANSFORM(account_am)

should