Unfortuantelly, the TRANSFORM() function is affected by SET DECIMAL setting and it does round result if it has more decimal spaces than specified by SET DECIMAL .

lnValue = 1.98765
SET DECIMALS TO 2    && Default
? TRANSFORM(lnValue,"9.9999")
SET DECIMALS TO 4
? TRANSFORM(lnValue,"9.9999")
SET DECIMALS TO 5
? TRANSFORM(lnValue,"9.9999")

>It seems that my table values when put through the TRANSFORM() function does some rounding up. Is this true?
>
>Such as:
>
<snip>