Script to Find and Update Extra Spaces in String / Column

There come to some scenarios when you need to find out and update Extra Spaces within your Data

Here is the Script to Find Extra Spaces in Column:

SELECT
[Rno]
,[Name] AS StringWithSpace
,LTRIM(RTRIM(REPLACE(REPLACE(REPLACE([Name],CHAR(32),'()'),')(',''),'()',CHAR(32)))) AS StringWithoutSpace
FROM tbl_RemoveExtraSpaces


Here is the Script to Update Extra Spaces in Column:

UPDATE tbl_RemoveExtraSpaces SET Name = LTRIM(RTRIM(REPLACE(REPLACE(REPLACE([Name],CHAR(32),'()'),')(',''),'()',CHAR(32))))

Happy Coding !!!