Re: Squeezing spaces out of a string

Assume '<' and '>' do not appear in col_x.

UPDATE Foobar

   SET col_x

• REPLACE ( REPLACE ( REPLACE(col_x, SPACE(1), '<> '), '><', SPACE(0)),
  '<>', SPACE(1));
  

This is due to a guy named Carnegie; Steve Kass found it in an old posting. The only problem is that it fails if the the first function call overflows the maximum string length. You might get errors, or truncation depending on your SQL. Received on Wed Feb 04 2004 - 12:37:40 CST