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.