>So does anyone know why MS made the TRANSFORM function respect the SET DECIMALS setting? If I have a field that is N(12,5) and it contains 0.11111 and I transform with:
>
>

>? TRANSFORM(FldName, "999,999.99999")
>

>
>I get 0.11000 if SET DECIMALS is 2, but 0.11111 if SET DECIMALS is 5.
>
>Seems kind of odd to me.

Well, that's how it is. Re: TRANSFORM() question Thread #1126152 Message #1126159