""equator9"" <john@...> wrote in message
news:a49l5c+b87m@......

>
> I now need to change all the table entries to 3 significant places.

Make sure your db is dialect 3.
Connect with a dialect 3 client. The easiest and simplest is isql, the
command-line utility. It's in the bin directory of the engine.
Define your field then. It will store exactly the number of decimals you
need.
Note: changing the dialect from 1 to 3 with gfix DOESN'T upgrade the
underlying storage for a numeric field. If the field was created in dialect
1, it will remain as double precision internally if its precision was
greater than 9. You can add a new field to the table in dialect 3, transfer
the values with an update statement, then drop the old field and rename the
new one to the old name if you like.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing