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”


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.