string[] parts = s.Split(new char[] { ' ', '\t' });
return string.Join(" ", parts);

C# Screw (11/18/2009)

---

Florian Reischl (11/18/2009)

---

Hi C# Screw

Good point, maybe try this instead of the StringBuilder:

string[] parts = s.Split(new char[] { ' ', '\t' });
return string.Join(" ", parts);

But I think the char-loop based solutions will still be much faster, since they do less memory copies.

Greets
Flo

Hi Flo
I tried the above but it is returning the original string

string[] parts = s.Split(new char[] { ' ', '\t' }, StringSplitOptions.RemoveEmptyEntries);
return string.Join(" ", parts);

CREATE FUNCTION dbo.fn_CleanUp_MichaelMeierruth_MKII(@S VARCHAR(8000))
RETURNS VARCHAR(8000)
BEGIN
RETURN   replace(replace(replace(replace(replace(replace(replace(ltrim(rtrim(@s)),
  '                                 ',' '),
  '                 ',' '),
  '         ',' '),
  '     ',' '),
  '   ',' '),
  '  ',' '),
  '  ',' ')
END