After reading Jeff Moden’s article “Replace Multiple Spaces with One” describing an approach to collapse white space in a string, I was troubled by the need for a temporary placeholder. I’m generally skeptical of any solution that requires picking a character that doesn’t naturally occur in the data. It just feels like you are building [...]
Filed under: How To..., Technology Tips | Tagged: SQL, Strings, tSQL | 1 Comment »
