SQL statement for removing consecutive separators from strings in sqlserver

The following test is used to remove the separator from any string.
Copy codeThe 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)