Dear community friends, I am having problem in converting a character to numeric and back to character again The idea is to get only the numbers without the "0" in the beginning For example, the number is 0012345678901230042 and I want to the new field to result as 12345678901230042 I tried using the following syntax: LEFT(PUT(input(Account_ID,BEST19.0),19.)) end as MainAccountID The result is 12345678901230040 with Character format Seems the last number is being rounded down by the system Really appreciate if anyone can give some help Thanks a lot
... View more