Convert Numberic(11,3) Leading Zero's and Remove Decimal
Hi Experts,
Need to add leading zeros and remove the decimal for a field w/format numberic(11,3).
sample data converted data
----------- -------------------
1234.123 00001234123
123.120 00000123120
9.900 00000009900
456.000 45600000000
TiA!
Need to add leading zeros and remove the decimal for a field w/format numberic(11,3).
sample data converted data
----------- -------------------
1234.123 00001234123
123.120 00000123120
9.900 00000009900
456.000 45600000000
TiA!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER