Make 'phone' fields consistent size

When updating a contact record's phone number, we received the error 'String or binary data would be truncated.  Error encountered updating tblEngagement'.  The error occurred because tblContacts.ContPhone allows 40 characters, but tblEngagement.ClientCreditPhone only allows 20 characters.  (The phone number we attempted to enter was 21 characters.)  Is it difficult to get these two fields to match?


Please sign in to leave a comment.