>Try ALLTRIM(STR(VAL('004'))). That will eliminate the leading zeroes. I hope this helps.
I would suggest using LTRIM instead of ALLTRIM - single function. Converting numerics will not produce trailing spaces so no need to trim them! I know I'm fussy!!