Tag: Replace

SQL: REPLACE Multiple Spaces with One

I have just found a very useful article from SQLServerCentral.com, that goes through the process of┬áreplacing multiple spaces with one. “Replacing multiple spaces with a single space is an old problem that people use loops, functions, and/or Tally tables for. Here’s a set based method for replacing multiple spaces from MVP Jeff Moden” http://www.sqlservercentral.com/articles/T-SQL/68378/