Replace duplicate spaces with single space in TSQL
Posted
by Chris
on Stack Overflow
See other posts from Stack Overflow
or by Chris
Published on 2010-03-16T15:37:56Z
Indexed on
2010/03/16
15:41 UTC
Read the original article
Hit count: 420
Filed under:
sql-server
|tsql
I need to ensure that a given field does not have more than one space (not concerned about all white space, just space) between characters.
So
'single spaces only'
Needs to turn into
'single spaces only'
The below will not work
select replace('single spaces only',' ',' ')
as it would result in
'single spaces only'
I would really prefer to stick with native TSQL rather than a CLR based solution.
Thoughts?
© Stack Overflow or respective owner
