Thanks for the info, Arne. I hadn't thought of checking with the USPS. Good idea!

>>I'm enhancing a customer master table to go from the North American standard of City (c-15), State (c-2), Zip (c-10) and Phone (c-14) to a more international version.
>>
>>I know that the most flexible option would be to give the user a memo field and let them do whatever. However, they want to keep the current "city, state zip" format intact for "domestic" companies and some alternate field(s) for others.
>>
>>Current thoughts are to use a Country drop-down that would let us "toggle" which address fields are enabled. What special kinds of things/lengths should I expect? (like Prefects, Districts, Regions, Postalcodes, etc.)
>>
>>On phone numbers, what is the longest?
>>
>>I really need to hear your comments and suggestions. TIA.
>
>Most of the european countries use a 1 to 3 letter country code and a postal code, the largest of which I have seen is 8 characters (british). E.g. N-0468 Oslo, D-38023 Braunschweig, P-1700 Lisboa. Though not needed, it is not unusual to add the country name. In England they use a slightly different format, like London WC2H 7EA. Not too fond of standardizing, the british :-)
>The longest european phone number I've found was 10 characters, not including country code or blanks for formating (british again). Formatting standards seem to vary between countries.
>This is not based on official information, solely on personal experiences. The US postal services might be able to supply you with more info?
>
>Arne