how to remove in between spaces in sql code example

Example 1: remove spaces sql 2008

SELECT RTRIM(LTRIM(' Word '))

Example 2: remove all spaces from string sql

SELECT REPLACE(' Hello World ',' ')