Month: November 2009

SQL: REPLACE Multiple Spaces with One

I have just found a very useful article from, 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”