Hi Simmon you can also try STR(85.74,32,14) this will return 85.73999999999999
but if you issue TRANSFORM(85.74, REPLICATE("9", 17) + "." + REPLICATE("9", 14)) this will give the correct result.
>Hi Alexandre
>
>Do you know why issuing a STR(85.76,32,14) gives me
>" 85.76000000000001" I want to know where the spurious 1 is coming from at the end. I'm sure I've read something somewhere about the limited accuracy of decimal places when converting to a string but I can't remember where
>
>Thanks
>
>Simon
Alexandre Palma
Senior Application Architect