I have a rule that I always follow about field types. If you are not going to do any math on a field, make it character. If the fact that your field is integer is what is causing the problem then I would suggest making it character. I would suggest making it character anyway to avoid any other future problems.
Larry Collins
TheProgrammerGuy.com