Use the 'REPLACE' function

declare @Words varchar(255)

select @Words = 'This is a test of the REPLACE FUNCTION'

select replace(@words,' ', '')