The phone number field would only allow numeric characters, this was ok until you try to input a phone number like 999-555-1212, the result would be "999". So I changed the phone field to 'varchar(20)', this will allow non-numeric characters and also gives plenty of room for a 10-digit phone number (with international code and dashes) plus 4 digit extension with spaces.