TRANSFORM(nRate, "99.99999")However, in a test case where nRate is 0.5425, the above statement returns 0.54. Interestingly enough, when no format code is used, TRANSFORM() will return 0.5425. Obviously, I know I can change the code to use ALLTRIM(STR()), but I don't understand why the above statement does any rounding whatsoever on a numeric value that clearly does not exceed the size of the format.