>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.
Just because you made numeric field smaller than values you have in it.
What do you mean with "phone number mask was not working properly with it as a string"?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.