[RESOLVED] [MS SQL SERVER 2000] resize numeric value..

[Asgorath]

Hi.
I a table with several fields declared as decimal(3,1) not null i am trying to change it to decimal(3,2) not null.

alter table artenc alter column prazo_ind decimal(3,2) not null
Server: Msg 8115, Level 16, State 8, Line 1
Arithmetic overflow error converting numeric to data type numeric.
The statement has been terminated.

Any suggestions? Thanks.

[brucevde]

decimal(3,2) means the range of values you can store in this field are from -9.99 to 9.99

Obviously, an existing value like 10.5 falls outside this range, thus the error.

If you want to change to 2 decimal places use decimal(4,2).

[Asgorath]

Thanks its working now.