>I have one customer who has a problem with a database changing structure. The structure changes from N(10,3) to to N(10).
>
>Is there a command to check the precision of the field and change it using alter table Alter Column ?
>
>Don

BTW, you may try to find records that present a problem with this select statement

select * from myTable where MyFieldToChange != int(myFieldToChange)