It also truncates the string if there are double spaces.
I used:
'This Is a Test of this function'
it returned
'This Is A Test'
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/