Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Excerpt

This data type is applied to numeric data following common patterns that express telephone numbers and known valid phone numbers in the United States.

  • 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.

    Info

    NOTE: Spaces within a group of values are not supported and will result in a mismatched data type entry.


  • In addition to validation against common phone patterns, values are checked against permitted U.S. phone numbers. For example, an area code value of 123 is invalid.

Standard Domestic U.S:

Code Block
###-###-#####
(###)-###-#####
##########
1##########

...