We have a form that was created under 9.2, we have moved to version 10.1 last week.   There is a number field for the employee ID.   Some are 2 numbers: 59, some are 3 numbers 191, some are 4: 1511.  In the field we instructed everyone to use 0059, 0191 and 1511  so the lookups will work.  In Forms this  lookup still seems to work - HOWEVER when the FORM is submitted the number put in the FORMS database seems to lose the leading zeros and the corresponding workflow that use these 2 or 3 digit fail.

When I look at the tokens in the failed Workflows - the employee id does not  have the leading zeros.   When I test the query with the id showing in the tokens the lookup fails, when I add the leading zeros the query works.   When a employee with a 4 digit ID runs the FORM and the attached Workflow the query is successful.

The query in Workflow is a simple lookup - not a custom query.   How do I get FORMS to save all 4 digits including the leading zeros in it's database?  OR how do I get workflow to add leading zeros to the simple lookup?  OR am I going to  have to change the query to a custom query to add in the leading zeros?

Any help would be appreciated.   Thanks.