Bad decision IMHO. Only fields that are subject to be part of a calculation should be numeric.

You probably have a phone number that is bigger than the lenght you specified for your numeric field. Increase the size of the numeric field, or better yet, use a character field instead.

>I am getting a numeric overflow when I am updating a 2500 or so phone numbers. From what I have read, this error typically comes from dividing by zero. Does anyone have any idea why I would get this when simply updating phone numbers without any mathematical manipulation?
>
>I recently changed this field to numeric from character because the phone number mask was not working properly with it as a string.