I'm having a very strange problem. I got some measurement data in SQL Server 2000 table, which I would like to copy to another table. INSERT INTO.. works well, but for some reason all negative values (data type = float) are not imported at all. In both tables the data type is the same (float). INSERT INTO tMeasurementData (MeasurementDataID, MeasurementValue, Comment) SELECT MeasurementDataID, MeasurementValue, Comment FROM tTEMP_tMeasurementData Actual measurement data can be either NULL, positive, or negative value (with decimals). Any ideas? Is there something I'm missing here..?