Removing leading '0' while decimal to varchar conversion
Posted: Tue Mar 24, 2015 7:17 pm
Hi,
I have a decimal field of length (38,0) in my source table. In the target I want to put it as a varchar field.
I am using the TRIM function to remove leading '0's from the source field but '0's are not getting removed. Now I am using DecimalToString function which is working fine.
But I am still curious to know why trim function below is not working.
trim(field,"0","L")
I have a decimal field of length (38,0) in my source table. In the target I want to put it as a varchar field.
I am using the TRIM function to remove leading '0's from the source field but '0's are not getting removed. Now I am using DecimalToString function which is working fine.
But I am still curious to know why trim function below is not working.
trim(field,"0","L")