bitbucket-25253 (9/23/2012)
Scroll down to about the middle of the page to see the explanation.
That's just the SQL Server 2000 version of the same Books Online link to CAST and CONVERT I have in my reply 🙂
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi