Hi,

Try this,

SELECT CAST(CAST(1.67574 AS DECIMAL(38,10)) / CAST(10000 AS DECIMAL(38,10)) AS DECIMAL(38,10)) conv_factor

SQL server taking a default scale, you need to explicitly specify the precision and scale.

regards

Hari