REPLACE Multiple Spaces with One
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on Fri, 17 Aug 2012 06:00:00 UT
Indexed on
2012/08/28
3:47 UTC
Read the original article
Hit count: 198
Filed under:
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 from MVP Jeff Moden.
“Thanks for building such a useful and simple-to-use service” - Steve Harshbarger, CTO, 10th Magnitude. Get started with Red Gate Cloud Services and back up your SQL Azure databases to Azure Blob storage or Amazon S3 – download a free trial today. |
© SQL Server Central or respective owner