Remove spaces from an nvarchar in SQL code example

Example: remove spaces sql 2008

SELECT RTRIM(LTRIM(' Word '))