Quote:
Originally posted by chuzhoi
One of the ways is char and rtrim combo
values rtrim( char ( 1.2345 ) )
You need rtrim to remove trailing spaces
|
Well.. you can't use rtrim on decimal... so that won't work. when I tranfer Decimal to character it will have the leading zeros and does not have trainling spaces to remove.. so i end up with leading zeros..