Replace Multiple Spaces in String with Single Space.

DECLARE @str_val varchar(1500)
SET @str_val = 'Hello    Welcome   to   DotNetFunda.com'
Select REPLACE(REPLACE(REPLACE(@str_val,' ','{}'),'}{',''),'{}',' ')