I have two tables on two different DB's, within two different servers. Both tables have the same structure and both DB's are of the same version ( 9.2.0.4). The column in question is of datatype NUMBER, w/o scale or precision. If I log on to Server1, connect to DB1, and query the table's column, the results are returned in SQL*Plus with the decimal portion of the value intact. If I log onto Server2, connect to DB2, and query the table's column, the results are returned in SQL*Plus w/o the decimal portion of the value. If I log onto Server1, start SQL*Plus, then connect to DB2 remotely and query the data, the results are returned in SQL*Plus w/o the decimal portion of the value. The session settings are identical via the SHOW ALL, and I've verified that the decimals are present on DB2 using a to_char and setting NUMFORMAT. Anyone have any ideas why? James