Please rate this item: 1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

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/

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.

CJayMead's SQL Server, Endeca, MS Office Help © 2018