So i need to add leading zero to a set of numbers within a table that i imported into databricks from a CSV in doing so i lost the leading zeros, the format of the number should be like this
0999
0010
0009
i have
999
10
9
i tried this
UPDATE Test table name
SET IID = '0' + IID
Resulting in
999.0
10.0
9.0
any ideas please
0999
0010
0009
i have
999
10
9
i tried this
UPDATE Test table name
SET IID = '0' + IID
Resulting in
999.0
10.0
9.0
any ideas please