Introduction:
Here I will explain how to replace multiple spaces in string with single space in sql server or sql server replace multiple spaces with one space in string or sql server remove extra multiple spaces from string without using any while loop.
Here I will explain how to replace multiple spaces in string with single space in sql server or sql server replace multiple spaces with one space in string or sql server remove extra multiple spaces from string without using any while loop.
Description:
In
previous articles I explained replace function example in sql server, Query to remove first and last character from string in sql
server, remove html tags from string in sql, substring function in SQL server
and many articles relating to SQL
server.
Now I will explain how to replace multiple spaces in string with single space
in sql
server.
To
replace multiple spaces in string with single space in sql
server we
need to write the query like this