>What is the best way of handling phone numbers in fields.
>
>I initialy thought to have a char field and just place a number in it.
>
>ex:
>
>8005551212
>
>then use an input mask and format (xxx) xxx-xxxx ext. xxxxxxxxx to display the number to the user.
That's the good choice, and it's exactly what Inputmask and Format are for...
Use Format R
and Inputmask (999) 999-9999
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.