Making a query some fields contains a lot of decimals (field type NUMBER(13,6)) in this way:
Code: Select all
CAST(thefield AS FLOAT)
- result In dbForge for SQL Server: 0.35999999999999999
result in SQL Server Management Studio: 0.36
Thanks
Code: Select all
CAST(thefield AS FLOAT)