Hi Folks
Source is a decimal(17,4) target is Varchar(50) . values in the decimal input can be negative . In the target leading '0' to be trimmed and 2 decimals are needed after point(.).
For positive integers TRIM does the trick , but stuck up with negative decimals(since start char is a '-' sign) TRIM would not work .
Suggestions appreciated!
Rounding decimal values
Moderators: chulett, rschirm, roy