>>Alter table mytable alter column myfield N(3,3)
>
>Actually if you need 3 decimal places, then you need a field width of 4. One is needed to hold the decimal point.
>
>Alter table mytable alter column myfield N(4,3)
Thanks for catching my oversight.
Mark McCasland
Midlothian, TX USA