>TRANSFORM function in turn has a bug.
>According to KB Article Q247494 "You might see that the results of the TRANSFORM() function appear off by approximately .0000000000001. This behavior may occur when COMPATIBLE is OFF."
Nice catch, Sergey. That would be something else to watch out for.
FWIW, working with the code in Q247494, if you use ALLTRIM(STR(i,17,15)) instead of TRANSFORM(i) the problem shows up even if SET COMPATIBLE is ON.
Rick Borup, MCSD
recursion (rE-kur'-shun) n.
see recursion.