Hi Bill,
First you have to leave the country (2 digits) or a plus sign The country code is 1 to 3 digits ( 1 = USA, Germany = 49, China=86 and small countries 3 digits) In Holland the max length of a phonenumber is 9 digits, but I don't think this is enough for China J Hope this helps Tony From: [email protected] [mailto:[email protected]] On Behalf Of William Stacy Sent: zondag 27 maart 2011 21:01 To: RBASE-L Mailing List Subject: [RBASE-L] - telephone number formatting Am restructuring my telephone number table so that just in case there is a way to direct dial from an Rbase 9.1 application. I'd want it to be consistent with whatever kind of dialers there are, which means like a 10 integer string for a cell phone in the USA, adding a 1 if it's a land line in the usa dialing to another usa long distance, or a 7 int. string if it's a local call, and something else for each if it's an overseas call. What else is there? Has anyone tackled this question? i'm thinking a tel column that is a text type of at least 11 chars (any longer ones in existence, esp foreign?) I would think that such an autodial column would have to have no hyphens, parens, etc. Thanks. Bill -- William Stacy, O.D. Please visit my website by clicking on : http://www.folsomeye.net

