Quote:
Originally posted by chuzhoi
Probably I do not understand something, but I said you should use 2 functions char AND rtrim
First will convert to character with possible trailing spaces, the second will remove them
regards,
dmitri
|
When you convert it to char it will have leading zeros infront of the decimal. So, using the trim will not remove those zeros cos it wud not have any trailing space. when you convert decimall to character you will not get trailing spaces instead you will get zeros in form of the number.
Fora example say you specify deciaml (18,3) and hold a value of 12.5.
when you change this to char you will have 0000012.500 somthing like that.
So, i need to emove those leading zeros.