Hi
You can use the following expression to remove the leading/trailing spaces resulting from decimal to varchar conversion.

replace(replace(rtrim(ltrim(replace(char(<FIELD_NAME>), '0', ' '))), ' ', '0'), '.', '')

Regards
Ankur Jain

http://ankurjain.org