Remove space from string in SQL Server

We can write our own script for removing blank space from string in SQL Server.

DECLARE @Str NVARCHAR(100)
DECLARE @RepStr NVARCHAR(100)
DECLARE @C INT
SET @Str = 'I want to learn SQL Server'
SET @RepStr = ''

SET @C = 1

WHILE (@C <=LEN(@Str))
BEGIN

    IF(SUBSTRING(@Str,@C,1) != ' ')
    SET @RepStr = @RepStr+SUBSTRING(@Str,@C,1)
  
    SET @C = @C + 1

END
SELECT @RepStr

That's It.
Enjoy Learning.