OK - this might be stretching the "Is this Useful" question a bit, but hey, I needed it today and thought I would share it with you - it's free! This construct takes the whitespace out of a string.
Removes extra white spaces between two words in a character string
SET@TEXT = 'Buck Woody'
SET@I = CHARINDEX (' ' , @TEXT )