I am trying to do set a field to specific format using the functions but can not get exactly what I want. It is a 5 character string and needs to end up as a 5 character string. The pattern is that I leave all leading 0 and pad right up to 3 - the number of leading 0 if leading is more than 1. Any suggestion on this would be greatly appreciated. 12566 goes to 12000 11456 goes to 11000 10456 goes to 10000 09456 goes to 09000 08456 goes to 08000 00956 goes to 00900 00096 goes to 00090 00009 goes to 00009
However beautiful the strategy, you should occasionally look at the results. Sir Winston Churchill _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
