Formatting a Field
Using a script, I populated a table from another table. I inserted data into the fields of a column named "Key." The data in the source table is of type Number. The source data has no decimal and no trailing 0s. When I populated the table, the data inserted has a decimal and 4 trailing zeros. How do I get rid of the zeros?
What's weird is that the script I used is a copy of a script I used to do the same exact thing on another table. The other table was populated with no decimal and no trailing zeros. Odd. . . .