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

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.

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).

Thanks its working now.