This is an old revision of the document!

Microsoft - Microsoft SQL Server - SQL - Format - Convert Multiple and Duplicate Spaces to Single Space

Using a WHILE loop with REPLACE

SQL QUERY

DECLARE @TestString VARCHAR(200);
SET @TestString='   Ex      ample   St  ring   ';
WHILE CHARINDEX('  ',@TestString) <> 0  SET @TestString = REPLACE(@TestString,'  ',' ');
SELECT @TestString AS RESULT;

or

DECLARE @TestString VARCHAR(200);
SET @TestString='   Ex      ample   St  ring   ';
WHILE CHARINDEX('  ',@TestString) <> 0  SET @TestString = REPLACE(@TestString,'  ',' ');
SELECT LTRIM(RTRIM(@TestString)) AS RESULT;