Jon,

>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()).

After some further testing I came to the conclusion that the TRANSFORM function was pretty slow anyway. I decided to use to test the number of decimals and transform it onto character with the STR() function. To my surprise it was even faster than a single TRANSFORM function (more than 2 times faster). Since the routine i'm using is time critical, the solution I found is better than using TRANSFORM, even withouth the bug.

Walter,