>hi all,
>
>we have a field in an application that the cusotmer has started using for multiple things and they wish to continue using it that way. initially they may enter some text (20 char field) like COVER COONFIRMED but later they want to enter a PO number that they must supply to their customer to get paid. this PO number if abotu 10 chars long and is comprised of just numbers. they want to ensure that i don't allow them to create an invoice without their being only numbers in this field. I was thinking about going through every character in the field to make sure it is numeric, is there an easier way of doing this?
>
>~M

Hi,
Naomi has answered the question but I have a more general one. AFAIK a purchase order number is usually supplied by the buyer and, in my experience, is just as likely to have alphabetic content as not. Is your client going to dictate the format of the P.O number?

Update: Oh - I misread. I see your client is the buyer.....