Replace duplicate spaces with single space in TSQL
- by Chris
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?