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

The only problem with using ALLTRIM(STR()) is that if the size and number of decimal places isn't indicated, you only get the integer portion of the number (?ALLTRIM(STR(9.2)) && returns 9).