SQL statement for removing contiguous delimiters in a string in SQL Server _mssql

The following tests are used to remove the line separator in any string

Copy Code code as follows:

--removing consecutive delimiters in a string
declare @str nvarchar (200)
Declare @split nvarchar, @times int
Set @str = ' China 1 2 34 55 5 6 7 7 ';--character
Set @split = '; --Separator
Select @times = (len (@str)-len (replace (@str, @split + @split, '))/2
While @times >0
Begin
Set @str =replace (@str, @split + @split, ")
Set @times = @times-1
End
Select @str

I hope it works for everyone.

Test results:

China 1 2 34 55 5 6 7 7

(1 rows affected)