I just had this discussion the other day with someone. I posted some code where I used ALLTRIM(STR()), and someone pointed out to use TRANSFORM() instead. Since I've never really used TRANSFORM() before, I thought I would see if there were any issues with it on Microsoft's Knowledge Base. I found the article that George Tasker mentioned, so I decided to stick with ALLTRIM(STR()).

I guess this doesn't really help much for what you're doing. However, I guess you could save the COMPATIBLE setting, turn it on, do your TRANSFORM(), then restore COMPATIBLE. You probably won't want to leave COMPATIBLE on any longer than that, because it can mess up the way a lot of other functions work.

>Hi all,
>
>TRANSFORM(9.2) seems to output 9.199999999999999
>
>Can anyone confirm this bug ???
>
>Walter,