Luis Cazares (8/29/2012)
It should be char or varchar.Ideally you should only store the digits and format the phone in the front end. However, you'll need an extra field for extension if needed.
This. Believe me, you will be much happier writing code going forward when all you have to deal with is xxxxxxxxxx.