RemoveExtraSpaces.sql

CREATE FUNCTION [dbo].[fnRemoveSpaces](
	@string_text VARCHAR(MAX),
	@threshold int = 3
)
RETURNS VARCHAR(MAX)
AS
BEGIN

	DECLARE @tempText AS VARCHAR(MAX)
	SET @tempText = replace(@string_text, char(10), ' ')
	SET @tempText = replace(@string_text, char(13), ' ')

	WHILE CHARINDEX(SPACE(@threshold),@tempText) > 0
	BEGIN
		SET @tempText = REPLACE(@tempText, SPACE(@threshold), ' ')
	END

	

	RETURN @tempText