Activity overview
Latest activity by eroach99
The compare apparently rounds at 13 decimal places - in our case there were more data past 13 decimal places - we used the following to see this :
select cast(column as decimal(25,15)) from table / comments
The compare apparently rounds at 13 decimal places - in our case there were more data past 13 decimal places - we used the following to see this :
select cast(column as decimal(25,15)) from table
That was it exactly - once I queried the fields and CAST them out further I saw the exact values. / comments
That was it exactly - once I queried the fields and CAST them out further I saw the exact values.
Comparison of float data types.
Hi,
Having trouble comparing float data types. If the value is too large, compare comes up un-equal. Is this supposed to work?????