This data type is applied to numeric data following common patterns that express telephone numbers.
- Parentheses are optional around area code values:
(###) ###-####
- Phone numbers may or may not include the
1
at their beginning. Dashes and spaces are optional between groups of numbers.
NOTE: Spaces within a group of values are not supported and will result in a mismatched data type entry.
Standard Domestic U.S:
###-###-##### (###)-###-##### ########## 1##########
Standard Domestic U.S. with extensions:
(###)-###-#### x ###
- The dash in
###-####
is required when extension is present. - The extension indicator can be one of the following:
x
,X
,ext
, orEXT
.
International U.S:
+1(###)-###-####
Not supported:
Local U.S. format not supported:
###-####
International format:
+##-##-###-#####
Internal international format not supported:
##-##-##-###-#####
This page has no comments.