LFreehauf
asked on
remove decimal and pad with zeros.
Experts: I need t-sql in a select statement to
1. remove a decimal
2. and pad the number with zeros to a set number of 9 characters.
Example of values in field: sMTD
152.25 should be 000015225
12646.25 should be 001264625
1366.54 should be 000136654
13.05 should be 000001305
1. remove a decimal
2. and pad the number with zeros to a set number of 9 characters.
Example of values in field: sMTD
152.25 should be 000015225
12646.25 should be 001264625
1366.54 should be 000136654
13.05 should be 000001305
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.