SQL statement for removing consecutive separators from strings in sqlserver

SQL statements that remove consecutive separators from strings in sqlserver. For more information, see

SQL statements that remove consecutive separators from strings in sqlserver. For more information, see

The following test is used to remove the separator from any string.
The Code is as follows:
-- Remove consecutive delimiters from strings
Declare @ str nvarchar (200)
Declare @ split nvarchar (200), @ times int
Set @ str = 'China 1 2 34 55 5 6 7 7'; -- character
Set @ split = ''; -- delimiter
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

Hope it will be helpful to everyone

Test results:

China 1 2 34 55 5 6 7 7

(One row is affected)