If you're like me, you've probably typed in LTRIM(RTRIM([value])) hundreds, if not thousands, of times during your travels through SQL Server. I've long wondered why there was no integrated function that would serve this purpose.
Pinal Dave (@pinaldave) has submitted an item on Microsoft Connect to suggest the TRIM() function as an addition to Transact-SQL. He correctly points out that most programming languages have this feature baked in.
So if you're on board with the movement to add TRIM() to T-SQL, log in to Microsoft Connect and add your vote and comments.