I try to replace a numeric field with str() but not work
STR() will transform a numeric value to a character string. You most likely will trigger an error if you are trying to replace a numeric field with a character string.
If the values are both numeric try:
REPLACE accountchr WITH int(account_am)
>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