SQL string cleanup - trim, remove/replace special whitespace characters (such as tab, newline) Originates from http://stackoverflow.com/questions/951518/replace-a-newline-in-tsql/24068265
Because this is just a single stored procedure, I really don't care what you do with the code. I ask politely for attribution if you found it helpful, but I'd settle for an upvote on SO and/or a comment/follow on my blog! Cheers.