If you can make the field a character field (I am assuming that the original entry has the leading zero where required) your problem should be solved - unless you also need the values as numerics for some other purpose.
Alternatively create a calculated field from the original field using the STR function to generate a character field and include the leading zero(s)to pad out the string.
You can then use either field as required for you purpose.
I hope this helps.
Is there a way in Monarch 7.02 to append a leading zero? I have a field that is suppose to be 3 digits long, but when the system generates the report it leaves off leading zero. However, I need that zero for other process.
You can refer to this [url="http://mails.datawatch.com/cgi-bin/ultimatebb.cgi?ubb=get_topic;f=1;t=000361#000005"]thread[/url] to properly pad a field with zeroes.
[size="1"][ May 01, 2006, 05:33 PM: Message edited by: Todd Niemi ][/size]